APPS.PAY_CA_RL1_REG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 97: number on pay_assignment_actions to province

93: in c_all_asg c_all_asg_set cursor in
94: action creation. Bug 2633035.
95: 04-Nov-2003 ssouresr 115.22 Using pre_organization_id instead of Quebec
96: Business Number. Also updating the serial
97: number on pay_assignment_actions to province
98: archived assignment action and payroll action id
99: 11-Feb-2004 ssouresr 115.23 Sort_action query was modified to eliminate dups
100: 16-Feb-2004 ssouresr 115.24 Taken out join to hr_locations from assignment
101: cursors and from sort_action

Line 180: pay_assignment_actions paa

176: ff_database_items fdi2,
177: ff_archive_items fai3,
178: ff_database_items fdi3,
179: pay_payroll_actions ppa,
180: pay_assignment_actions paa
181: where ppa.payroll_action_id = :payroll_action_id
182: and fai1.user_entity_id = fdi1.user_entity_id
183: and fdi1.user_name = ''CAEOY_TAXATION_YEAR''
184: and fai1.value =

Line 260: pay_assignment_actions paa

256: cp_pre_org_id in varchar2) is
257: select paa.assignment_action_id,
258: ppa.payroll_action_id
259: from pay_payroll_actions ppa,
260: pay_assignment_actions paa
261: where ppa.report_type = 'RL1'
262: and ppa.report_qualifier = 'CAEOYRL1'
263: and ppa.report_category = 'CAEOYRL1'
264: and ppa.effective_date = l_year_end

Line 471: select pay_assignment_actions_s.nextval

467: ln_arch_pact_id;
468: if c_archived_person_info%notfound then
469: hr_utility.trace('No Archived Person Found');
470: else
471: select pay_assignment_actions_s.nextval
472: into lockingactid
473: from dual;
474:
475: hr_nonrun_asact.insact(lockingactid,

Line 491: update pay_assignment_actions paa

487: lpad(to_char(ln_arch_pact_id),14,0);
488:
489: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
490:
491: update pay_assignment_actions paa
492: set paa.serial_number = lv_serial_number
493: where paa.assignment_action_id = lockingactid;
494:
495: l_prev_person_id := l_person_id;

Line 592: select pay_assignment_actions_s.nextval

588: ln_arch_pact_id;
589: if c_archived_person_info%notfound then
590: hr_utility.trace('No Archived Person Found');
591: else
592: select pay_assignment_actions_s.nextval
593: into lockingactid
594: from dual;
595:
596: hr_nonrun_asact.insact(lockingactid,

Line 611: update pay_assignment_actions paa

607: lpad(to_char(ln_arch_pact_id),14,0);
608:
609: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
610:
611: update pay_assignment_actions paa
612: set paa.serial_number = lv_serial_number
613: where paa.assignment_action_id = lockingactid;
614:
615: l_prev_person_id := l_person_id;

Line 656: pay_assignment_actions paa1,

652: hr_all_organization_units hou,
653: hr_locations_all loc,
654: per_all_people_f ppf,
655: per_all_assignments_f paf,
656: pay_assignment_actions paa1,
657: pay_payroll_actions ppa1
658: where ppa1.payroll_action_id = :pactid
659: and paa1.payroll_action_id = ppa1.payroll_action_id
660: and paa1.assignment_id = paf.assignment_id