APPS.PAY_US_GARN_UPGRADE dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 556: from pay_status_processing_rules_f

552: effective_end_date,
553: assignment_status_type_id,
554: formula_id,
555: processing_rule
556: from pay_status_processing_rules_f
557: where element_type_id in (select element_type_id
558: from pay_element_types_f
559: where element_type_id = cp_ele_type_id
560: and business_group_id = cp_bg_grp_id);

Line 575: from pay_status_processing_rules_f psprf,

571: pfrrf.result_name,
572: pfrrf.result_rule_type,
573: pfrrf.severity_level,
574: pfrrf.element_type_id
575: from pay_status_processing_rules_f psprf,
576: pay_element_types_f petf,
577: pay_formula_result_rules_f pfrrf
578: where petf.element_type_id = cp_ele_type_id
579: and petf.business_group_id = cp_bg_grp_id

Line 607: from pay_status_processing_rules_f psprf,

603: * Delete the formula result rules for the Old element.
604: */
605: delete from pay_formula_result_rules_f
606: where status_processing_rule_id in (select distinct status_processing_rule_id
607: from pay_status_processing_rules_f psprf,
608: pay_element_types_f petf
609: where petf.element_type_id = p_old_ele_type_id
610: and psprf.element_type_id = petf.element_type_id
611: and petf.business_group_id = p_business_grp_id);

Line 612: delete from pay_status_processing_rules_f

608: pay_element_types_f petf
609: where petf.element_type_id = p_old_ele_type_id
610: and psprf.element_type_id = petf.element_type_id
611: and petf.business_group_id = p_business_grp_id);
612: delete from pay_status_processing_rules_f
613: where element_type_id in (select distinct element_type_id
614: from pay_element_types_f
615: where element_type_id = p_old_ele_type_id
616: and business_group_id = p_business_grp_id);

Line 928: from pay_status_processing_rules_f

924: -- Cursor to get the status_processing_rule_id
925: cursor c_get_stat_proc_rules(cp_ele_name varchar2,
926: cp_bg_grp_id number) IS
927: select status_processing_rule_id
928: from pay_status_processing_rules_f
929: where element_type_id in (select element_type_id
930: from pay_element_types_f
931: where element_name = cp_ele_name
932: and business_group_id = cp_bg_grp_id);

Line 1067: FROM pay_status_processing_rules_f psprf

1063: DELETE
1064: FROM pay_formula_result_rules_f
1065: WHERE status_processing_rule_id
1066: IN (SELECT status_processing_rule_id
1067: FROM pay_status_processing_rules_f psprf
1068: WHERE psprf.element_type_id = l_element_type_id );
1069:
1070: DELETE
1071: FROM pay_status_processing_rules_f

Line 1071: FROM pay_status_processing_rules_f

1067: FROM pay_status_processing_rules_f psprf
1068: WHERE psprf.element_type_id = l_element_type_id );
1069:
1070: DELETE
1071: FROM pay_status_processing_rules_f
1072: WHERE element_type_id = l_element_Type_id;
1073:
1074: /* Delete the Input Values associated with the Base Element */
1075: DELETE