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_ELEMENT_CLASSIFICATIONS

Line 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

1449: and pet.element_type_id = prr.element_type_id
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;

Line 1627: pay_element_classifications pec,

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,
1630: pay_balance_dimensions pbd
1631: where pec.classification_name ='Employer Liabilities'

Line 1657: pay_element_classifications pec,

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'
1660: and pec.legislation_code ='US'
1661: and pet.classification_id = pec.classification_id

Line 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

1668: and prr.element_type_id +0 = pet.element_type_id
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;

Line 1688: pay_element_classifications pec,'

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'''||
1691: ' and pec.legislation_code ='||'''US'''||
1692: ' and pet.classification_id = pec.classification_id

Line 2258: pay_element_classifications pec,

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,
2261: pay_us_emp_fed_tax_rules_F pftr,
2262: pay_us_states pst,

Line 2307: pay_element_classifications pec,

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,
2310: pay_us_emp_fed_tax_rules_F pftr,
2311: pay_us_states pst,

Line 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

2330: and pst.state_code = substr(pftr.sui_jurisdiction_code,1,2)
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);

Line 2355: pay_element_classifications pec,

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,
2358: pay_us_emp_fed_tax_rules_F pftr,
2359: pay_us_states pst,'