APPS.PAY_US_GARN_UPGRADE dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 549: from pay_status_processing_rules_f

545: effective_end_date,
546: assignment_status_type_id,
547: formula_id,
548: processing_rule
549: from pay_status_processing_rules_f
550: where element_type_id in (select element_type_id
551: from pay_element_types_f
552: where element_type_id = cp_ele_type_id
553: and business_group_id = cp_bg_grp_id);

Line 568: from pay_status_processing_rules_f psprf,

564: pfrrf.result_name,
565: pfrrf.result_rule_type,
566: pfrrf.severity_level,
567: pfrrf.element_type_id
568: from pay_status_processing_rules_f psprf,
569: pay_element_types_f petf,
570: pay_formula_result_rules_f pfrrf
571: where petf.element_type_id = cp_ele_type_id
572: and petf.business_group_id = cp_bg_grp_id

Line 600: from pay_status_processing_rules_f psprf,

596: * Delete the formula result rules for the Old element.
597: */
598: delete from pay_formula_result_rules_f
599: where status_processing_rule_id in (select distinct status_processing_rule_id
600: from pay_status_processing_rules_f psprf,
601: pay_element_types_f petf
602: where petf.element_type_id = p_old_ele_type_id
603: and psprf.element_type_id = petf.element_type_id
604: and petf.business_group_id = p_business_grp_id);

Line 605: delete from pay_status_processing_rules_f

601: pay_element_types_f petf
602: where petf.element_type_id = p_old_ele_type_id
603: and psprf.element_type_id = petf.element_type_id
604: and petf.business_group_id = p_business_grp_id);
605: delete from pay_status_processing_rules_f
606: where element_type_id in (select distinct element_type_id
607: from pay_element_types_f
608: where element_type_id = p_old_ele_type_id
609: and business_group_id = p_business_grp_id);

Line 921: from pay_status_processing_rules_f

917: -- Cursor to get the status_processing_rule_id
918: cursor c_get_stat_proc_rules(cp_ele_name varchar2,
919: cp_bg_grp_id number) IS
920: select status_processing_rule_id
921: from pay_status_processing_rules_f
922: where element_type_id in (select element_type_id
923: from pay_element_types_f
924: where element_name = cp_ele_name
925: and business_group_id = cp_bg_grp_id);

Line 1060: FROM pay_status_processing_rules_f psprf

1056: DELETE
1057: FROM pay_formula_result_rules_f
1058: WHERE status_processing_rule_id
1059: IN (SELECT status_processing_rule_id
1060: FROM pay_status_processing_rules_f psprf
1061: WHERE psprf.element_type_id = l_element_type_id );
1062:
1063: DELETE
1064: FROM pay_status_processing_rules_f

Line 1064: FROM pay_status_processing_rules_f

1060: FROM pay_status_processing_rules_f psprf
1061: WHERE psprf.element_type_id = l_element_type_id );
1062:
1063: DELETE
1064: FROM pay_status_processing_rules_f
1065: WHERE element_type_id = l_element_Type_id;
1066:
1067: /* Delete the Input Values associated with the Base Element */
1068: DELETE