[Home] [Help]
170:
171: cursor csr_check_action(l_mode1 varchar2, l_mode2 varchar2) is
172: select 1
173: from pay_payroll_actions pay,
174: pay_assignment_actions paa
175: where (pay.report_type like l_mode1
176: or
177: pay.report_type like l_mode2) -- Bug 6770200.
178: and pay.action_status ='C'
231: cursor csr_aei_details is
232: select aei.assignment_extra_info_id,
233: aei.object_version_number,
234: aei.aei_information1
235: from pay_assignment_actions paa,
236: per_assignment_extra_info aei
237: where paa.assignment_action_id = p_assact
238: and aei.assignment_id = paa.assignment_id
239: and aei.information_type = p_type;
331: is
332: select 1
333: from pay_action_information pa
334: ,pay_payroll_actions ppa
335: ,pay_assignment_actions paa
336: where pa.action_information_category in 'GB P46_5 EDI'
337: and pa.action_context_type = 'AAP'
338: and pa.action_information4 = default_archive
339: and pa.assignment_id = p_assignment_id
343:
344: cursor csr_p46_5_def_assact(p_assignment_id number) is
345: select act.assignment_action_id
346: from pay_payroll_actions pact,
347: pay_assignment_actions act
348: where pact.report_type = 'P46_5'
349: and pact.action_status ='C'
350: and pact.report_qualifier = 'GB'
351: and pact.report_category = 'EDI'
429: end if;
430: end if;
431: if l_arch then
432: hr_utility.set_location('Creating assignment action for ' || asg_rec.assignment_id,30);
433: select pay_assignment_actions_s.nextval
434: into l_ass_act_id
435: from dual;
436: --
437: -- insert into pay_assignment_actions.
433: select pay_assignment_actions_s.nextval
434: into l_ass_act_id
435: from dual;
436: --
437: -- insert into pay_assignment_actions.
438: hr_nonrun_asact.insact(l_ass_act_id,
439: asg_rec.assignment_id,
440: pactid,
441: chunk,
625: select /*+ ORDERED */
626: asg.assignment_id,
627: asg.effective_start_date,
628: asg.effective_end_date
629: from pay_assignment_actions paa,
630: per_assignments_f asg
631: where paa.assignment_action_id = p_assactid
632: and paa.assignment_id = asg.assignment_id
633: and p_effective_date between asg.effective_start_date and asg.effective_end_date;
637: -- Earlier code was checking run results first, then if values not found
638: -- there, then it was going for element entry values.
639: /*
640: cursor csr_max_run_result(p_element_id number) is
641: select /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
642: pact PAY_PAYROLL_ACTIONS_PK,
643: r2 PAY_RUN_RESULTS_N50)
644: USE_NL(assact2, pact, r2) */
645: /* to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type|| r2.run_result_id),17))
642: pact PAY_PAYROLL_ACTIONS_PK,
643: r2 PAY_RUN_RESULTS_N50)
644: USE_NL(assact2, pact, r2) */
645: /* to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type|| r2.run_result_id),17))
646: from pay_assignment_actions assact2,
647: pay_payroll_actions pact,
648: pay_run_results r2
649: where assact2.assignment_id = l_assignment_id
650: and r2.element_type_id+0 = p_element_id
656: and pact.effective_date between l_asg_start and l_asg_end
657: and not exists(
658: select '1'
659: from pay_action_interlocks pai,
660: pay_assignment_actions assact3,
661: pay_payroll_actions pact3
662: where pai.locked_action_id = assact2.assignment_action_id
663: and pai.locking_action_id = assact3.assignment_action_id
664: and pact3.payroll_action_id = assact3.payroll_action_id
902: pap.national_identifier,
903: pap.sex,
904: fnd_date.date_to_canonical(pap.date_of_birth) date_of_birth,
905: fnd_date.date_to_canonical(decode(pap.current_employee_flag, 'Y', serv.date_start, null)) hire_date
906: from pay_assignment_actions act,
907: per_assignments_f paa,
908: per_people_f pap,
909: per_periods_of_service serv
910: where act.assignment_action_id = p_assactid
916: and p_effective_date between pap.effective_start_date and pap.effective_end_date;
917:
918: cursor csr_job is
919: select pay_get_job_segment_pkg.get_job_segment(paa.business_group_id,job.job_definition_id,act.payroll_action_id) job
920: from pay_assignment_actions act,
921: per_assignments_f paa,
922: per_jobs job
923: where act.assignment_action_id = p_assactid
924: and act.assignment_id = paa.assignment_id
1276: is
1277: select 1
1278: from pay_action_information pa
1279: ,pay_payroll_actions ppa
1280: ,pay_assignment_actions paa
1281: where pa.action_information_category = 'GB P46_5 EDI'
1282: and pa.action_context_type = 'AAP'
1283: and pa.action_information4 = 'Y'
1284: and pa.assignment_id = p_person_rec.assignment_id
1690: l_archive_type VARCHAR2(20);
1691:
1692: cursor csr_archive_type is
1693: select report_type
1694: from pay_assignment_actions paa,
1695: pay_payroll_actions ppa
1696: where paa.assignment_action_id = p_assactid
1697: and paa.payroll_action_id = ppa.payroll_action_id;
1698:
1917: peo.title title,
1918: paf.assignment_number emp_no,
1919: peo.national_identifier ni_no
1920: from pay_payroll_actions pay,
1921: pay_assignment_actions paa,
1922: per_all_assignments_f paf,
1923: per_all_people_f peo
1924: where pay.payroll_action_id = pactid
1925: and paa.payroll_action_id = pay.payroll_action_id
1977: pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
1978: /*ppa.effective_date*/
1979: sysdate
1980: from pay_payroll_actions ppa
1981: ,pay_assignment_actions paa
1982: where paa.assignment_action_id = c_assignment_action_id
1983: and ppa.payroll_action_id = paa.payroll_action_id;
1984:
1985: