APPS.PAY_PAYSGSOE_XMLP_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 8: select max(pai.locked_action_id) from pay_action_interlocks pai

4: function cf_gross_pay_currformula(assignment_action_id in number, person_id in number) return number is
5: v_gross_pay_curr number;
6: v_ass_act_id pay_assignment_actions.assignment_action_id%type;
7: cursor c_pay_ass_act_id(v_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
8: select max(pai.locked_action_id) from pay_action_interlocks pai
9: where pai.locking_action_id = v_assignment_action_id;
10: begin
11: open c_pay_ass_act_id(assignment_action_id);
12: fetch c_pay_ass_act_id into v_ass_act_id;