APPS.PAY_CA_RL2_REG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 79: pay_assignment_actions paa_arch

75: from pay_action_information pai1,
76: pay_action_information pai2,
77: pay_payroll_actions ppa_reg,
78: pay_payroll_actions ppa_arch,
79: pay_assignment_actions paa_arch
80: where ppa_reg.payroll_action_id = :payroll_action_id
81: and pai1.action_context_type = ''PA''
82: and pai1.action_information1 = ''RL2''
83: and pai1.action_information_category = ''CAEOY TRANSMITTER INFO''

Line 153: pay_assignment_actions paa

149: cp_pre_org_id in varchar2) is
150: select paa.assignment_action_id,
151: ppa.payroll_action_id
152: from pay_payroll_actions ppa,
153: pay_assignment_actions paa
154: where ppa.report_type = 'RL2'
155: and ppa.report_qualifier = 'CAEOYRL2'
156: and ppa.report_category = 'ARCHIVE'
157: and ppa.effective_date = l_year_end

Line 193: pay_assignment_actions paa

189: l_year_end date) is
190: select distinct paa.assignment_id,
191: to_number(paa.serial_number)
192: from pay_payroll_actions ppa,
193: pay_assignment_actions paa
194: where ppa.report_type = 'RL2'
195: and ppa.report_qualifier = 'CAEOYRL2'
196: and ppa.report_category = 'ARCHIVE'
197: and ppa.effective_date = l_year_end

Line 230: pay_assignment_actions paa

226: l_per_id varchar2) is
227: select distinct paa.assignment_id,
228: to_number(paa.serial_number)
229: from pay_payroll_actions ppa,
230: pay_assignment_actions paa
231: where ppa.report_type = 'RL2'
232: and ppa.report_qualifier = 'CAEOYRL2'
233: and ppa.report_category = 'ARCHIVE'
234: and ppa.effective_date = l_year_end

Line 264: pay_assignment_actions paa

260: l_year_end date) is
261: select distinct paa.assignment_id,
262: to_number(paa.serial_number)
263: from pay_payroll_actions ppa,
264: pay_assignment_actions paa
265: where ppa.report_type = 'RL2'
266: and ppa.report_qualifier = 'CAEOYRL2'
267: and ppa.report_category = 'ARCHIVE'
268: and ppa.effective_date = l_year_end

Line 406: select pay_assignment_actions_s.nextval

402: if c_archived_person_info%notfound then
403: hr_utility.trace('No Archived Person Found');
404: else
405:
406: select pay_assignment_actions_s.nextval
407: into lockingactid
408: from dual;
409:
410: hr_nonrun_asact.insact(lockingactid,

Line 423: update pay_assignment_actions paa

419: lpad(to_char(ln_arch_pact_id),14,0);
420:
421: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
422:
423: update pay_assignment_actions paa
424: set paa.serial_number = lv_serial_number
425: where paa.assignment_action_id = lockingactid;
426:
427: l_prev_person_id := l_person_id;

Line 519: select pay_assignment_actions_s.nextval

515: if c_archived_person_info%notfound then
516: hr_utility.trace('No Archived Person Found');
517: else
518:
519: select pay_assignment_actions_s.nextval
520: into lockingactid
521: from dual;
522:
523: hr_nonrun_asact.insact(lockingactid,

Line 536: update pay_assignment_actions paa

532: lpad(to_char(ln_arch_pact_id),14,0);
533:
534: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
535:
536: update pay_assignment_actions paa
537: set paa.serial_number = lv_serial_number
538: where paa.assignment_action_id = lockingactid;
539:
540: l_prev_person_id := l_person_id;

Line 582: pay_assignment_actions paa1,

578: hr_all_organization_units hou,
579: hr_locations_all loc,
580: per_all_people_f ppf,
581: per_all_assignments_f paf,
582: pay_assignment_actions paa1,
583: pay_payroll_actions ppa1
584: where ppa1.payroll_action_id = :pactid
585: and paa1.payroll_action_id = ppa1.payroll_action_id
586: and paa1.assignment_id = paf.assignment_id