APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 1232: l_sub_classification_rule_id pay_sub_classification_rules_f.sub_classification_rule_id%type;

1228: l_effective_end_date_li date;
1229: l_entries_warning_li boolean;
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;

Line 1336: from pay_sub_classification_rules_f

1332: End if;
1333:
1334: select rowid, sub_classification_rule_id
1335: into l_rowid, l_sub_classification_rule_id
1336: from pay_sub_classification_rules_f
1337: where element_type_id = p_element_type_id
1338: and business_group_id = p_business_group_id;
1339:
1340: select classification_id

Line 1711: ,pay_sub_classification_rules_f pscr

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

Line 1961: ,pay_sub_classification_rules_f pscr

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