DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 1508: ,pay_sub_classification_rules_f pscr

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'
1512: and (instr(pec.classification_name, 'Earnings') > 0

Line 1758: ,pay_sub_classification_rules_f pscr

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'
1762: AND pet.element_type_id = pscr.element_type_id (+)