APPS.PAY_CA_PAYROLL_UTILS dependencies on PAY_FILE_DETAILS

Line 81: FROM pay_file_details pfd

77:
78: CURSOR c_get_file_payroll_asgact (p_payactid NUMBER) IS
79: SELECT
80: pfd.file_detail_id
81: FROM pay_file_details pfd
82: WHERE pfd.source_id = p_payactid;
83:
84: CURSOR c_get_file_asgact (p_payactid NUMBER) IS
85: SELECT

Line 87: FROM pay_file_details pfd

83:
84: CURSOR c_get_file_asgact (p_payactid NUMBER) IS
85: SELECT
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);

Line 93: l_file_detid pay_file_details.file_detail_id%type;

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;
95: aalist asg_act_list;
96:
97: BEGIN

Line 104: FROM pay_file_details

100: into l_file_detid;
101: close c_get_file_payroll_asgact;
102:
103: DELETE
104: FROM pay_file_details
105: WHERE file_detail_id = l_file_detid;
106:
107: open c_get_file_asgact(p_payroll_action_id);
108: loop

Line 111: delete from pay_file_details

107: open c_get_file_asgact(p_payroll_action_id);
108: loop
109: fetch c_get_file_asgact bulk collect into aalist limit 1000;
110: forall i in 1..aalist.count
111: delete from pay_file_details
112: where file_detail_id = aalist(i);
113:
114: exit when c_get_file_asgact%notfound;
115: end loop;