#techno

Sunday, February 19, 2017

Oracle Fusion HCM:Query for Balance Definitions within Balance Group

The below query is useful to get the balances with in the balance group. Balance group is group of balances used in reporting purpose, mainly in requirement like to get sum of particular balances. We can create a Balance group for particular set of balances. We can use below query to find what are the balances in the defined balance group.

The more info about balance group from oracle is in below link

http://docs.oracle.com/cloud/farel11/globalcs_gs/FAIGP/FAIGP1427196.htm#FAIGP1655173

The query is,

Select pbg.base_group_name
, pbt.base_balance_name
, pbgu.BASE_GROUP_USAGE_NAME
, pbd.dimension_level
, pbd.period_type
, pbd.base_dimension_name
, pbd.base_db_item_suffix
, pbc.base_category_name
from PAY_BALANCE_GROUPS pbg,
PAY_BAL_GRP_USAGES pbgu,
PAY_BAL_GRP_INCLUSIONS pbgi,
PAY_BAL_ATT_DEFINITIONS pbad,
PAY_BALANCE_ATTRIBUTES pba,
PAY_DEFINED_BALANCES pdb,
PAY_BALANCE_TYPES pbt,
PAY_BALANCE_DIMENSIONS Pbd,
PAY_BALANCE_CATEGORIES_F pbc
where pbg.base_group_name like :P_Balance_group_name
and pbg.balance_group_id = pbgi.balance_group_id
and pbg.balance_group_id = pbgu.balance_group_id
and pbad.attribute_id = pbgi.attribute_id
and pbad.attribute_id = pba.attribute_id
and pdb.defined_balance_id = pba.defined_balance_id
and pbt.balance_type_id = pdb.balance_type_id
and pbd.balance_dimension_id = pdb.balance_dimension_id
and pbc.balance_category_id = pbt.balance_category_id
and sysdate between pbc.effective_start_date and pbc.effective_end_date
order by pbg.base_group_name

Thursday, June 26, 2014

A responsive login form using HTML5 and CSS3

Hii,This is a login form designed using HTML5 and CSS3.You can go to below link and check out the sample code and you can work on that by applying different styles.

click here for the code

have fun..

Monday, June 23, 2014

Hii
Like our official facebook page

Go to our facebook page

How to create a simple navigation bar using css and html

Hi,You can go to below link and check out the sample code and you can work
on that by applying different styles.

Fork and play with this code on uiCod.com

Fork and play with this code on uiCod.com

click here

enjoy...

Wednesday, June 11, 2014

How to use drag and drop in a webpage using HTML and JS

HTML5 is the latest version of HTML it has capability to deliver rich internet applications without using any additional plugins.So we can make hi-end web applications using HTML5.HTML5 is cross-platform so that work with different devices.

This tutorial will teach you how to use drag and drop feature of HTML5 to drag an object (say image) from one place to other in a web page.

Step 1:#createfile

Create the html file.

Open notepad and type the codes as given below:

<!DOCTYPE HTML>
<html>
<head>
<style>
p {font-family: "Times New Roman";font-size: 20px;}
#divbox {width:350px;height:70px;padding:10px;border:5px solid #aaaaaa;}
</style>
<script>
function DropPermission(ev) {
    ev.preventDefault();
}

function drag(ev) {
    ev.dataTransfer.setData("Text", ev.target.id);
}

function drop(ev) {
    ev.preventDefault();
    var data = ev.dataTransfer.getData("Text");
    ev.target.appendChild(document.getElementById(data));
}
</script>
</head>
<body>

<p>Drag the helloworld image into the rectangle:</p>

<div id="divbox" ondrop="drop(event)" ondragover="DropPermission(event)"></div>
<br>
<img id="drag1" src="hello.jpg" draggable="true" ondragstart="drag(event)" width="336" height="69">

</body>
</html>

Step 2:#save

Save your notepad file in .html format

Step 3:#execution

Note:HTML5 doesn’t support older browsers.Execute this file in any latest browsers.I here use Google Chrome.

You can see the output as given below

Read Full Story »

Thursday, May 29, 2014

How to see your current location in Google map using HTML 5

HTML 5 is the latest version of HTML it has capability to deliver rich internet applications without using any additional plugins.So we can make hi-end web applications using HTML 5. HTML 5 is cross-platform so that work with different devices.

This tutorial will teach you how to use geolocation feature in HTML 5 to get your current location on Google map.

Step 1:#createfile

create the html file.

Open notepad and type the codes as given below:

#source code:

Read Full Story »

Wednesday, May 28, 2014

How to create image border using HTML5 and CSS3

We can use images as borders in our html page so that borders can be more attractive

Check out my #experiments:

Step 1:#create file

create the html file with CSS3 style specification.

Note:CSS3 is the latest addition and the CSS3 specification is still under development by w3c. It supports all modern browsers but u can get compatibility issues in IE and older versions of other browsers.I use Google chrome.so,I recommend to try this on Google chrome.

Open notepad and type the codes as given below:

<!DOCTYPE html>
<html>
<head>
<style> 
div
{
border:15px solid transparent;
width:250px;
padding:10px 20px;
}

#tiles
{

border-image:url(img.png) 30 30 round;<!--insert your image url here -->
}

#stretch
{

border-image:url(img.png) 20 0 stretch;<!--insert your image url here -->
}
</style>
</head>
<body>
<div id="tiles">the image is tiled</div>
<br>
<div id="stretch">the image is stretched</div>
<p>original image:</p>
<img src="img.png"><!--insert your image url here -->
</body>
</html>

Read Full Story »

Tuesday, May 27, 2014

How to create matrix like effect using batch programming

Every one might have wondered about the cool green animation on matrix movie. Let’s try to generate an emulation of matrix effect using batch file programming.

Step 1:create batch file

Open notepad

Type the following code as you see in screen shot:

Read Full Story »