APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 225: FROM pay_status_processing_rules_f pspfr,

221: --
222:
223: CURSOR cur_processing_rule_exists(p_element_type_id number) is
224: SELECT status_processing_rule_id
225: FROM pay_status_processing_rules_f pspfr,
226: pay_element_types_f petf
227: WHERE pspfr.element_type_id = petf.element_type_id
228: AND petf.element_type_id = p_element_type_id;
229:

Line 1224: FROM pay_status_processing_rules_f

1220: AND upper(name) = 'AMOUNT';
1221:
1222: CURSOR c_base_elmt_spr_id IS
1223: SELECT status_processing_rule_id
1224: FROM pay_status_processing_rules_f
1225: WHERE element_type_id = p_base_element_type_id;
1226:
1227: l_iter_formula_id NUMBER;
1228: l_iter_rule_id NUMBER;