eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GTNLOD_PKG dependencies on PAY_BALANCE_TYPES

Line 1454: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE; --#Bug 13351417 Modified the declaration from varchar2(60) to pay_balance_types.balance_name%type

1450: and prr.assignment_action_id = l_assignment_action_id;
1451: /*-- Bug#4942114 ends -- */
1452:
1453: l_classification_name PAY_ELEMENT_CLASSIFICATIONS.CLASSIFICATION_NAME%TYPE; --#Bug 13351417 Modified the declaration from varchar2(60) to pay_element_classifications.classification_name%type
1454: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE; --#Bug 13351417 Modified the declaration from varchar2(60) to pay_balance_types.balance_name%type
1455: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE; --#Bug 13351417 Modified the declaration from varchar2(60) to pay_element_types_f.element_name%type
1456: l_run_val number(20,2);
1457: l_status number :=0;
1458: l_jurisdiction_code varchar2(15); -- Bug 4443935

Line 1625: from pay_balance_types pbt,

1621: pbt.balance_name balance_name,
1622: /* Bug 5918981: element_name is replaced with reporting_name */
1623: -- nvl(pet.reporting_name, pet.element_name) element_name
1624: pet.element_name element_name /* Bug 14406013: Reverting back changes done as part of Bug 5918981 */
1625: from pay_balance_types pbt,
1626: pay_element_types_f pet,
1627: pay_element_classifications pec,
1628: pay_run_balances prb,
1629: pay_defined_balances pdb,

Line 1655: from pay_balance_types pbt,

1651: pbt.balance_name balance_name,
1652: /* Bug 5918981: element_name is replaced with reporting_name */
1653: -- nvl(pet.reporting_name, pet.element_name) element_name
1654: pet.element_name element_name /* Bug 14406013: Reverting back changes done as part of Bug 5918981 */
1655: from pay_balance_types pbt,
1656: pay_element_types_f pet,
1657: pay_element_classifications pec,
1658: pay_run_results prr
1659: where pec.classification_name ='Employer Liabilities'

Line 1673: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE; --#Bug 13351417 Modified the declaration from varchar2(60) to pay_balance_types.balance_name%type

1669: and prr.status in ('P','PA')
1670: and prr.assignment_action_id = l_assignment_action_id;
1671: /*-- Bug#4942114 ends -- */
1672: l_classification_name PAY_ELEMENT_CLASSIFICATIONS.CLASSIFICATION_NAME%TYPE; --#Bug 13351417 Modified the declaration from varchar2(60) to pay_element_classifications.classification_name%type
1673: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE; --#Bug 13351417 Modified the declaration from varchar2(60) to pay_balance_types.balance_name%type
1674: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE; --#Bug 13351417 Modified the declaration from varchar2(60) to pay_element_types_f.element_name%type
1675: l_run_val number(20,2);
1676: l_status number :=0;
1677: BEGIN

Line 1686: pay_balance_types pbt,

1682: 'select distinct pec.classification_name classification_name,
1683: pbt.balance_name balance_name,
1684: pet.element_name element_name
1685: from
1686: pay_balance_types pbt,
1687: pay_element_types_f pet,
1688: pay_element_classifications pec,'
1689: || l_er_liab_from||
1690: ' where pec.classification_name ='||'''Employer Liabilities'''||

Line 2256: pay_balance_types pbt,

2252: pet.element_name element_name, /* Bug 14406013: Reverting back changes done as part of Bug 5918981 */
2253: pftr.sui_jurisdiction_code jurisdiction_code,
2254: pst.state_name state_name
2255: from
2256: pay_balance_types pbt,
2257: pay_element_types_f pet,
2258: pay_element_classifications pec,
2259: pay_assignment_actions paa,
2260: per_all_assignments_f paf,

Line 2305: pay_balance_types pbt,

2301: pet.element_name element_name, /* Bug 14406013: Reverting back changes done as part of Bug 5918981 */
2302: pftr.sui_jurisdiction_code jurisdiction_code,
2303: pst.state_name state_name
2304: from
2305: pay_balance_types pbt,
2306: pay_element_types_f pet,
2307: pay_element_classifications pec,
2308: pay_assignment_actions paa,
2309: per_all_assignments_f paf,

Line 2335: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE; --#Bug 13351417 Modified the declaration from varchar2(60) to pay_balance_types.balance_name%type

2331: and prr.element_type_id +0 = pet.element_type_id
2332: and prr.assignment_action_id = paa.assignment_action_id;
2333: /*-- Bug#4942114 ends -- */
2334: l_classification_name PAY_ELEMENT_CLASSIFICATIONS.CLASSIFICATION_NAME%TYPE; --#Bug 13351417 Modified the declaration from varchar2(60) to pay_element_classifications.classification_name%type
2335: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE; --#Bug 13351417 Modified the declaration from varchar2(60) to pay_balance_types.balance_name%type
2336: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE; --#Bug 13351417 Modified the declaration from varchar2(60) to pay_element_types_f.element_name%type
2337: l_jurisdiction_code varchar2(11);
2338: l_run_val number(20,2);
2339: l_state_name varchar2(60);

Line 2353: pay_balance_types pbt,

2349: pet.element_name element_name,
2350: pftr.sui_jurisdiction_code jurisdiction_code,
2351: pst.state_name state_name
2352: from
2353: pay_balance_types pbt,
2354: pay_element_types_f pet,
2355: pay_element_classifications pec,
2356: pay_assignment_actions paa,
2357: per_all_assignments_f paf,