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.

[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1506: ,pay_element_classifications pec

1502: pet.retro_summ_ele_id, /* Bug 5731490 */
1503: decode(instr(pec.classification_name, 'Earnings'), 0, null,pec2.classification_name) ||
1504: decode(instr(pec.classification_name, 'Deductions'), 0, null, pec.classification_name ) label
1505: from pay_element_types_f pet
1506: ,pay_element_classifications pec
1507: ,pay_element_classifications pec2
1508: ,pay_sub_classification_rules_f pscr
1509: where pet.element_type_id = cp_element_type_id
1510: AND pet.classification_id = pec.classification_id

Line 1507: ,pay_element_classifications pec2

1503: decode(instr(pec.classification_name, 'Earnings'), 0, null,pec2.classification_name) ||
1504: decode(instr(pec.classification_name, 'Deductions'), 0, null, pec.classification_name ) label
1505: from pay_element_types_f pet
1506: ,pay_element_classifications pec
1507: ,pay_element_classifications pec2
1508: ,pay_sub_classification_rules_f pscr
1509: where pet.element_type_id = cp_element_type_id
1510: AND pet.classification_id = pec.classification_id
1511: and pec.legislation_code = 'AU'

Line 1745: pay_element_classifications pec

1741: /* select pet.business_group_id, pet.legislation_code, pet.classification_id,
1742: nvl(pet.retro_summ_ele_id, pet.element_type_id),
1743: pet.element_name, classification_name
1744: from pay_element_types_f pet,
1745: pay_element_classifications pec
1746: where pet.element_type_id = cp_element_type_id
1747: AND pet.classification_id = pec.classification_id
1748: AND pec.legislation_code = 'AU'
1749: order by pet.effective_start_date desc;*/

Line 1756: pay_element_classifications pec

1752: pet.element_name, pec.classification_name
1753: ,pet.retro_summ_ele_id
1754: ,decode(instr(pec.classification_name, 'Earnings'), 0, null,pec2.classification_name) label
1755: FROM pay_element_types_f pet,
1756: pay_element_classifications pec
1757: ,pay_element_classifications pec2
1758: ,pay_sub_classification_rules_f pscr
1759: WHERE pet.element_type_id = cp_element_type_id
1760: AND pet.classification_id = pec.classification_id

Line 1757: ,pay_element_classifications pec2

1753: ,pet.retro_summ_ele_id
1754: ,decode(instr(pec.classification_name, 'Earnings'), 0, null,pec2.classification_name) label
1755: FROM pay_element_types_f pet,
1756: pay_element_classifications pec
1757: ,pay_element_classifications pec2
1758: ,pay_sub_classification_rules_f pscr
1759: WHERE pet.element_type_id = cp_element_type_id
1760: AND pet.classification_id = pec.classification_id
1761: AND pec.legislation_code = 'AU'