APPS.PAY_GB_ENROLL_INFO_GENE dependencies on PAY_ACTION_INFORMATION

Line 157: cursor c_archive_details_check(p_assignment_id number,p_letter_type pay_action_information.action_information30%type) is

153: petf.effective_start_date and petf.effective_end_date;
154: l_temp number;
155:
156:
157: cursor c_archive_details_check(p_assignment_id number,p_letter_type pay_action_information.action_information30%type) is
158: select * from pay_action_information where
159: action_context_id in
160: (
161: SELECT assignment_action_id

Line 158: select * from pay_action_information where

154: l_temp number;
155:
156:
157: cursor c_archive_details_check(p_assignment_id number,p_letter_type pay_action_information.action_information30%type) is
158: select * from pay_action_information where
159: action_context_id in
160: (
161: SELECT assignment_action_id
162: FROM fnd_concurrent_programs fcp

Line 177: select * from pay_action_information where

173: AND action_information30=p_letter_type
174: AND ACTION_CONTEXT_TYPE='AAP';
175:
176: cursor c_archive_details_update (p_assignment_id number,p_period_id number) is
177: select * from pay_action_information where
178: action_context_id in
179: (
180: SELECT assignment_action_id
181: FROM fnd_concurrent_programs fcp

Line 297: pay_action_information_api.update_action_information

293: begin
294: fnd_file.put_line(fnd_file.LOG,'Entering update_archive');
295: l_ovn := p_archive_details_update.object_version_number;
296:
297: pay_action_information_api.update_action_information
298: ( p_action_information_id =>p_archive_details_update.action_information_id
299: ,p_object_version_number =>l_ovn
300: ,p_action_information1 =>p_archive_details_update.action_information1
301: ,p_action_information2 =>p_archive_details_update.action_information2