APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 922: from pay_status_processing_rules_f a

918:
919:
920: select distinct null
921: into l_null_return
922: from pay_status_processing_rules_f a
923: where exists
924: (select null
925: from hr_s_status_processing_rules_f b
926: where a.status_processing_rule_id=b.status_processing_rule_id

Line 1388: from pay_status_processing_rules_f spr

1384: BEGIN
1385:
1386: select distinct status_processing_rule_id
1387: into v_new_spr_id
1388: from pay_status_processing_rules_f spr
1389: where spr.legislation_code = r_distinct.legislation_code
1390: and spr.business_group_id is null
1391: and spr.processing_rule = sprs.processing_rule
1392: and ((spr.assignment_status_type_id is null

Line 1399: from pay_status_processing_rules_f spr2

1395: or
1396: (spr.assignment_status_type_id =
1397: sprs.assignment_status_type_id))
1398: and spr.effective_end_date = (select max(spr2.effective_end_date)
1399: from pay_status_processing_rules_f spr2
1400: where spr2.element_type_id = spr.element_type_id
1401: and spr2.processing_rule = spr.processing_rule
1402: and spr2.legislation_code = r_distinct.legislation_code
1403: and spr2.business_group_id is null

Line 1518: from pay_status_processing_rules_f a

1514: BEGIN
1515:
1516: select distinct null
1517: into l_null_return
1518: from pay_status_processing_rules_f a
1519: , pay_formula_result_rules_f b
1520: where a.element_type_id = l_new_element_type_id
1521: and b.status_processing_rule_id = a.status_processing_rule_id
1522: and b.effective_end_Date > r_distinct.c_end

Line 2024: from pay_status_processing_rules_f b

2020: delete from pay_formula_result_rules_f a
2021: where a.business_group_id is null
2022: and exists
2023: (select null
2024: from pay_status_processing_rules_f b
2025: where b.status_processing_rule_id = a.status_processing_rule_id
2026: and b.element_type_id = r_distinct.c_surrogate_key
2027: and b.business_group_id is null
2028: );

Line 2030: delete from pay_status_processing_rules_f

2026: and b.element_type_id = r_distinct.c_surrogate_key
2027: and b.business_group_id is null
2028: );
2029:
2030: delete from pay_status_processing_rules_f
2031: where element_type_id = r_distinct.c_surrogate_key
2032: and business_Group_id is null;
2033:
2034: delete from pay_element_types_f

Line 2505: insert into pay_status_processing_rules_f

2501:
2502: FOR all_rules IN all_p_rules(p_rules.s_rule_id) LOOP
2503:
2504: BEGIN
2505: insert into pay_status_processing_rules_f
2506: (STATUS_PROCESSING_RULE_ID
2507: ,EFFECTIVE_START_DATE
2508: ,EFFECTIVE_END_DATE
2509: ,BUSINESS_GROUP_ID

Line 2543: hr_utility.trace('ins pay_status_processing_rules_f');

2539: ,all_rules.CREATION_DATE
2540: );
2541: EXCEPTION WHEN OTHERS THEN
2542: hr_legislation.hrrunprc_trace_on;
2543: hr_utility.trace('ins pay_status_processing_rules_f');
2544: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2545: to_char(all_rules.STATUS_PROCESSING_RULE_ID));
2546: hr_utility.trace('ELEMENT_TYPE_ID ' ||
2547: to_char(all_rules.element_type_id));