APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_STATUS_PROCESSING_RULES_F

Line 757: from hr_s_status_processing_rules_f

753: -- same element type.
754: --
755: select distinct status_processing_rule_id s_rule_id,
756: assignment_status_type_id,processing_rule
757: from hr_s_status_processing_rules_f
758: where element_Type_id = pc_element_id;
759:
760: CURSOR all_p_rules(pc_stat_rule_id number)
761: IS

Line 766: from hr_s_status_processing_rules_f

762: -- Retrieves full details of processing rules for the insertiion into
763: -- live tables.
764:
765: select *
766: from hr_s_status_processing_rules_f
767: where status_processing_rule_id = pc_stat_rule_id;
768:
769: CURSOR frrs(pc_stat_rule_id number)
770: IS

Line 863: update /*+NO_INDEX*/ hr_s_STATUS_PROCESSING_RULES_F

859:
860: update /*+NO_INDEX*/ hr_s_INPUT_VALUES_F
861: set element_type_id = element_type_id - 50000000;
862:
863: update /*+NO_INDEX*/ hr_s_STATUS_PROCESSING_RULES_F
864: set element_type_id = element_type_id - 50000000;
865:
866: update /*+NO_INDEX*/ hr_s_SUB_CLASSN_RULES_F
867: set element_type_id = element_type_id - 50000000;

Line 925: from hr_s_status_processing_rules_f b

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
927: );
928:
929: --conflict may exist

Line 935: update hr_s_STATUS_PROCESSING_RULES_F

931:
932: update hr_s_FORMULA_RESULT_RULES_F
933: set status_processing_rule_id=status_processing_rule_id-50000000;
934:
935: update hr_s_STATUS_PROCESSING_RULES_F
936: set status_processing_rule_id=status_processing_rule_id-50000000;
937:
938: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
939:

Line 1040: from hr_s_status_processing_rules_f;

1036: select min(status_processing_rule_id) - (count(*) *3)
1037: , max(status_processing_rule_id) + (count(*) *3)
1038: into v_min_delivered
1039: , v_max_delivered
1040: from hr_s_status_processing_rules_f;
1041:
1042: select pay_status_processing_rules_s.nextval
1043: into v_sequence_number
1044: from dual;

Line 1152: from hr_s_status_processing_rules_f b

1148:
1149: delete from hr_s_formula_result_rules_f a
1150: where exists
1151: (select null
1152: from hr_s_status_processing_rules_f b
1153: where b.status_processing_rule_id = a.status_processing_rule_id
1154: and b.element_type_id = v_id
1155: );
1156:

Line 1157: delete from hr_s_status_processing_rules_f

1153: where b.status_processing_rule_id = a.status_processing_rule_id
1154: and b.element_type_id = v_id
1155: );
1156:
1157: delete from hr_s_status_processing_rules_f
1158: where element_type_id = v_id;
1159:
1160: END remove;
1161:

Line 1410: update hr_s_status_processing_rules_f

1406: hr_legislation.hrrunprc_trace_off;
1407: raise;
1408: END;
1409:
1410: update hr_s_status_processing_rules_f
1411: set status_processing_rule_id = v_new_spr_id
1412: , element_type_id = l_new_element_type_id
1413: where status_processing_rule_id = sprs.s_rule_id;
1414: