APPS.PQP_CANDM_UPG dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 63: ,PAY_STATUS_PROCESSING_RULES_F paf

59: ,fff.sticky_flag
60: ,fff.compile_flag
61: ,paf.status_processing_rule_id status_processing_rule_id
62: FROM ff_formulas_f fff
63: ,PAY_STATUS_PROCESSING_RULES_F paf
64: --,pay_element_types_f petf
65: WHERE (formula_name
66: LIKE NVL(p_formula_name,'%_MILEAGE_CLAIM_PVT')
67: )

Line 86: ,PAY_STATUS_PROCESSING_RULES_F paf

82: ,substr(fff.formula_name,0,(length(fff.formula_name)-12)) fname
83: ,fff.business_group_id
84: ,paf.status_processing_rule_id
85: FROM ff_formulas_f fff
86: ,PAY_STATUS_PROCESSING_RULES_F paf
87: WHERE formula_name=cp_formula_name
88: AND fff.business_group_id=cp_business_group_id
89: AND fff.business_group_id=paf.business_group_id
90: AND fff.formula_id=paf.formula_id

Line 103: FROM pay_status_processing_rules_f pspr

99: CURSOR c_elename(cformula_id number,cbusiness_group_id number) IS
100: SELECT element_name
101: FROM pay_element_types_f petf
102: WHERE element_type_id = (SELECT distinct(pspr.element_type_id)
103: FROM pay_status_processing_rules_f pspr
104: ,pay_element_type_extra_info pete
105: WHERE pspr.formula_id =cformula_id
106: AND pspr.business_group_id=cbusiness_group_id
107: AND pspr.business_group_id=petf.business_group_id

Line 270: UPDATE pay_status_processing_rules_f

266: ,1
267: ,sysdate
268: );*/
269:
270: UPDATE pay_status_processing_rules_f
271: SET formula_id=ff_formulas_s.currval
272: WHERE status_processing_rule_id=l_formula.status_processing_rule_id
273: AND sysdate BETWEEN effective_start_date and effective_end_date;
274: