[Home] [Help]
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
125:
126: 24-FEB-2009 sneelapa 115.35 Bug 7572889, Modified the CURSORS
127: c_all_asg, c_single_asg and c_all_asg_in_asgset
128: to fetch the data from "pay_payroll_actions"
129: and "pay_assignment_actions" tables.
130: 05-Sep-2011 rgottipa 115.36 Bug 10399514, introduced new cursores
131: c_all_asg_range, c_single_asg_range and
132: c_all_asg_in_asgset_range. These will be
133: called if RANGE_PERSON_ID is enabled.
192: ff_database_items fdi2,
193: ff_archive_items fai3,
194: ff_database_items fdi3,
195: pay_payroll_actions ppa,
196: pay_assignment_actions paa
197: where ppa.payroll_action_id = :payroll_action_id
198: and fai1.user_entity_id = fdi1.user_entity_id
199: and fdi1.user_name = ''CAEOY_TAXATION_YEAR''
200: and fai1.value =
282: cp_pre_org_id in varchar2) is
283: select paa.assignment_action_id,
284: ppa.payroll_action_id
285: from pay_payroll_actions ppa,
286: pay_assignment_actions paa
287: where ppa.report_type = 'RL1'
288: and ppa.report_qualifier = 'CAEOYRL1'
289: and ppa.report_category = 'CAEOYRL1'
290: and ppa.effective_date = l_year_end
309: , l_year_end date ) is
310: select distinct to_number(paa.serial_number),
311: paa.assignment_id assignment_id
312: from pay_payroll_actions ppa,
313: pay_assignment_actions paa
314: where ppa.report_type = 'RL1'
315: and ppa.report_qualifier = 'CAEOYRL1'
316: and ppa.report_category = 'CAEOYRL1'
317: and ppa.effective_date = l_year_end
329: , l_year_end date ) is
330: select distinct to_number(paa.serial_number),
331: paa.assignment_id assignment_id
332: from pay_payroll_actions ppa,
333: pay_assignment_actions paa,
334: pay_population_ranges ppr
335: where ppa.report_type = 'RL1'
336: and ppa.report_qualifier = 'CAEOYRL1'
337: and ppa.report_category = 'CAEOYRL1'
352: ,l_per_id varchar2) is
353: select distinct to_number(paa.serial_number),
354: paa.assignment_id assignment_id
355: from pay_payroll_actions ppa,
356: pay_assignment_actions paa
357: where ppa.report_type = 'RL1'
358: and ppa.report_qualifier = 'CAEOYRL1'
359: and ppa.report_category = 'CAEOYRL1'
360: and ppa.effective_date = l_year_end
373: ,l_per_id varchar2) is
374: select distinct to_number(paa.serial_number),
375: paa.assignment_id assignment_id
376: from pay_payroll_actions ppa,
377: pay_assignment_actions paa,
378: pay_population_ranges ppr
379: where ppa.report_type = 'RL1'
380: and ppa.report_qualifier = 'CAEOYRL1'
381: and ppa.report_category = 'CAEOYRL1'
398: ,l_year_end date ) is
399: select distinct to_number(paa.serial_number),
400: paa.assignment_id assignment_id
401: from pay_payroll_actions ppa,
402: pay_assignment_actions paa
403: where ppa.report_type = 'RL1'
404: and ppa.report_qualifier = 'CAEOYRL1'
405: and ppa.report_category = 'CAEOYRL1'
406: and ppa.effective_date = l_year_end
426: ,l_year_end date ) is
427: select distinct to_number(paa.serial_number),
428: paa.assignment_id assignment_id
429: from pay_payroll_actions ppa,
430: pay_assignment_actions paa,
431: pay_population_ranges ppr
432: where ppa.report_type = 'RL1'
433: and ppa.report_qualifier = 'CAEOYRL1'
434: and ppa.report_category = 'CAEOYRL1'
676: ln_arch_pact_id;
677: if c_archived_person_info%notfound then
678: hr_utility.trace('No Archived Person Found');
679: else
680: select pay_assignment_actions_s.nextval
681: into lockingactid
682: from dual;
683:
684: hr_nonrun_asact.insact(lockingactid,
697: lpad(to_char(ln_arch_pact_id),14,0);
698:
699: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
700:
701: update pay_assignment_actions paa
702: set paa.serial_number = lv_serial_number
703: where paa.assignment_action_id = lockingactid;
704:
705: l_prev_person_id := l_person_id;
865: ln_arch_pact_id;
866: if c_archived_person_info%notfound then
867: hr_utility.trace('No Archived Person Found');
868: else
869: select pay_assignment_actions_s.nextval
870: into lockingactid
871: from dual;
872:
873: hr_nonrun_asact.insact(lockingactid,
885: lpad(to_char(ln_arch_pact_id),14,0);
886:
887: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
888:
889: update pay_assignment_actions paa
890: set paa.serial_number = lv_serial_number
891: where paa.assignment_action_id = lockingactid;
892:
893: l_prev_person_id := l_person_id;
944: hr_all_organization_units hou,
945: hr_locations_all loc,
946: per_all_people_f ppf,
947: per_all_assignments_f paf,
948: pay_assignment_actions paa1,
949: pay_payroll_actions ppa1
950: where ppa1.payroll_action_id = :pactid
951: and paa1.payroll_action_id = ppa1.payroll_action_id
952: and paa1.assignment_id = paf.assignment_id