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 1367: from pay_status_processing_rules_f spr

1363: BEGIN
1364:
1365: select distinct status_processing_rule_id
1366: into v_new_spr_id
1367: from pay_status_processing_rules_f spr
1368: where spr.legislation_code = r_distinct.legislation_code
1369: and spr.business_group_id is null
1370: and spr.processing_rule = sprs.processing_rule
1371: and ((spr.assignment_status_type_id is null

Line 1378: from pay_status_processing_rules_f spr2

1374: or
1375: (spr.assignment_status_type_id =
1376: sprs.assignment_status_type_id))
1377: and spr.effective_end_date = (select max(spr2.effective_end_date)
1378: from pay_status_processing_rules_f spr2
1379: where spr2.element_type_id = spr.element_type_id
1380: and spr2.processing_rule = spr.processing_rule
1381: and spr2.legislation_code = r_distinct.legislation_code
1382: and spr2.business_group_id is null

Line 1497: from pay_status_processing_rules_f a

1493: BEGIN
1494:
1495: select distinct null
1496: into l_null_return
1497: from pay_status_processing_rules_f a
1498: , pay_formula_result_rules_f b
1499: where a.element_type_id = l_new_element_type_id
1500: and b.status_processing_rule_id = a.status_processing_rule_id
1501: and b.effective_end_Date > r_distinct.c_end

Line 1992: from pay_status_processing_rules_f b

1988: delete from pay_formula_result_rules_f a
1989: where a.business_group_id is null
1990: and exists
1991: (select null
1992: from pay_status_processing_rules_f b
1993: where b.status_processing_rule_id = a.status_processing_rule_id
1994: and b.element_type_id = r_distinct.c_surrogate_key
1995: and b.business_group_id is null
1996: );

Line 1998: delete from pay_status_processing_rules_f

1994: and b.element_type_id = r_distinct.c_surrogate_key
1995: and b.business_group_id is null
1996: );
1997:
1998: delete from pay_status_processing_rules_f
1999: where element_type_id = r_distinct.c_surrogate_key
2000: and business_Group_id is null;
2001:
2002: delete from pay_element_types_f

Line 2473: insert into pay_status_processing_rules_f

2469:
2470: FOR all_rules IN all_p_rules(p_rules.s_rule_id) LOOP
2471:
2472: BEGIN
2473: insert into pay_status_processing_rules_f
2474: (STATUS_PROCESSING_RULE_ID
2475: ,EFFECTIVE_START_DATE
2476: ,EFFECTIVE_END_DATE
2477: ,BUSINESS_GROUP_ID

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

2507: ,all_rules.CREATION_DATE
2508: );
2509: EXCEPTION WHEN OTHERS THEN
2510: hr_legislation.hrrunprc_trace_on;
2511: hr_utility.trace('ins pay_status_processing_rules_f');
2512: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2513: to_char(all_rules.STATUS_PROCESSING_RULE_ID));
2514: hr_utility.trace('ELEMENT_TYPE_ID ' ||
2515: to_char(all_rules.element_type_id));