DBA Data[Home] [Help]

APPS.PAY_PAYSGSOE_XMLP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 6: v_ass_act_id pay_assignment_actions.assignment_action_id%type;

2: /* $Header: PAYSGSOEB.pls 120.0 2007/12/13 12:23:31 amakrish noship $ */
3:
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

Line 7: cursor c_pay_ass_act_id(v_assignment_action_id pay_assignment_actions.assignment_action_id%type) is

3:
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);