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_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1234: l_classification_id pay_element_classifications.classification_id%type;

1230:
1231: /*bug 7665727*/
1232: l_sub_classification_rule_id pay_sub_classification_rules_f.sub_classification_rule_id%type;
1233: l_rowid varchar2(18) default null;
1234: l_classification_id pay_element_classifications.classification_id%type;
1235: dummy_rowid varchar2(18) default null;
1236: dummy_id number(38) default null;
1237:
1238: begin

Line 1342: from pay_element_classifications

1338: and business_group_id = p_business_group_id;
1339:
1340: select classification_id
1341: into l_classification_id
1342: from pay_element_classifications
1343: where classification_name = p_class_label /* Bug 8765082 */
1344: and legislation_code = 'AU';
1345:
1346: /* Deleting Standard sub classification*/

Line 1709: ,pay_element_classifications pec

1705: pet.retro_summ_ele_id, /* Bug 5731490 */
1706: decode(instr(pec.classification_name, 'Earnings'), 0, null,pec2.classification_name) ||
1707: decode(instr(pec.classification_name, 'Deductions'), 0, null, pec.classification_name ) label
1708: from pay_element_types_f pet
1709: ,pay_element_classifications pec
1710: ,pay_element_classifications pec2
1711: ,pay_sub_classification_rules_f pscr
1712: where pet.element_type_id = cp_element_type_id
1713: AND pet.classification_id = pec.classification_id

Line 1710: ,pay_element_classifications pec2

1706: decode(instr(pec.classification_name, 'Earnings'), 0, null,pec2.classification_name) ||
1707: decode(instr(pec.classification_name, 'Deductions'), 0, null, pec.classification_name ) label
1708: from pay_element_types_f pet
1709: ,pay_element_classifications pec
1710: ,pay_element_classifications pec2
1711: ,pay_sub_classification_rules_f pscr
1712: where pet.element_type_id = cp_element_type_id
1713: AND pet.classification_id = pec.classification_id
1714: and pec.legislation_code = 'AU'

Line 1959: pay_element_classifications pec

1955: pet.element_name, pec.classification_name
1956: ,pet.retro_summ_ele_id
1957: ,decode(instr(pec.classification_name, 'Earnings'), 0, null,pec2.classification_name) label
1958: FROM pay_element_types_f pet,
1959: pay_element_classifications pec
1960: ,pay_element_classifications pec2
1961: ,pay_sub_classification_rules_f pscr
1962: WHERE pet.element_type_id = cp_element_type_id
1963: AND pet.classification_id = pec.classification_id

Line 1960: ,pay_element_classifications pec2

1956: ,pet.retro_summ_ele_id
1957: ,decode(instr(pec.classification_name, 'Earnings'), 0, null,pec2.classification_name) label
1958: FROM pay_element_types_f pet,
1959: pay_element_classifications pec
1960: ,pay_element_classifications pec2
1961: ,pay_sub_classification_rules_f pscr
1962: WHERE pet.element_type_id = cp_element_type_id
1963: AND pet.classification_id = pec.classification_id
1964: AND pec.legislation_code = 'AU'