DBA Data[Home] [Help]

APPS.PAY_CA_USER_INIT_EARN dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 220: FROM pay_status_processing_rules_f pspfr,

216: --
217:
218: CURSOR cur_processing_rule_exists(p_element_type_id number) is
219: SELECT status_processing_rule_id
220: FROM pay_status_processing_rules_f pspfr,
221: pay_element_types_f petf
222: WHERE pspfr.element_type_id = petf.element_type_id
223: AND petf.element_type_id = p_element_type_id;
224:

Line 1216: FROM pay_status_processing_rules_f

1212: AND upper(name) = 'AMOUNT';
1213:
1214: CURSOR c_base_elmt_spr_id IS
1215: SELECT status_processing_rule_id
1216: FROM pay_status_processing_rules_f
1217: WHERE element_type_id = p_base_element_type_id;
1218:
1219: l_iter_formula_id NUMBER;
1220: l_iter_rule_id NUMBER;