DBA Data[Home] [Help]

APPS.PQP_CANDM_UPG dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 114: ,PAY_STATUS_PROCESSING_RULES_F paf

110: ,paf.status_processing_rule_id status_processing_rule_id
111: ,fff.formula_text
112: ,fff.legislation_code
113: FROM ff_formulas_f fff
114: ,PAY_STATUS_PROCESSING_RULES_F paf
115: WHERE fff.formula_name like NVL(p_formula_name,p_formula_cat)
116: AND fff.formula_id=paf.formula_id
117: AND paf.assignment_status_type_id IS NULL
118: AND fff.business_group_id=paf.business_group_id

Line 216: UPDATE pay_status_processing_rules_f

212: ,1
213: ,sysdate
214: );
215:
216: UPDATE pay_status_processing_rules_f
217: SET formula_id=ff_formulas_s.currval
218: WHERE status_processing_rule_id=l_formula.status_processing_rule_id
219: AND SYSDATE BETWEEN effective_start_date and effective_end_date;
220: