DBA Data[Home] [Help]

APPS.PAY_CA_PAYROLL_UTILS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 90: FROM pay_assignment_actions

86: pfd.file_detail_id
87: FROM pay_file_details pfd
88: WHERE pfd.source_id in (
89: SELECT assignment_action_id
90: FROM pay_assignment_actions
91: WHERE payroll_action_id = p_payactid);
92:
93: l_file_detid pay_file_details.file_detail_id%type;
94: type asg_act_list is table of pay_assignment_actions.assignment_action_id%type;

Line 94: type asg_act_list is table of pay_assignment_actions.assignment_action_id%type;

90: FROM pay_assignment_actions
91: WHERE payroll_action_id = p_payactid);
92:
93: l_file_detid pay_file_details.file_detail_id%type;
94: type asg_act_list is table of pay_assignment_actions.assignment_action_id%type;
95: aalist asg_act_list;
96:
97: BEGIN
98: open c_get_file_payroll_asgact (p_payroll_action_id);