[Home] [Help]
205:
206: cursor csr_check_action(l_mode1 varchar2, l_mode2 varchar2 , l_mode3 varchar2, l_mode4 varchar2) is --Changed for bug 9255173
207: select 1
208: from pay_payroll_actions pay,
209: pay_assignment_actions paa
210: where (pay.report_type like l_mode1
211: or
212: pay.report_type like l_mode2 -- Bug 6770200.
213: or
299: cursor csr_aei_details is
300: select aei.assignment_extra_info_id,
301: aei.object_version_number,
302: aei.aei_information1
303: from pay_assignment_actions paa,
304: per_assignment_extra_info aei
305: where paa.assignment_action_id = p_assact
306: and aei.assignment_id = paa.assignment_id
307: and aei.information_type = p_type;
401: is
402: select 1
403: from pay_action_information pa
404: ,pay_payroll_actions ppa
405: ,pay_assignment_actions paa
406: where pa.action_information_category in 'GB P46_5 EDI'
407: and pa.action_context_type = 'AAP'
408: and pa.action_information4 = default_archive
409: and pa.assignment_id = p_assignment_id
413:
414: cursor csr_p46_5_def_assact(p_assignment_id number) is
415: select act.assignment_action_id
416: from pay_payroll_actions pact,
417: pay_assignment_actions act
418: where pact.report_type = p_rep_type -- Changed to handle P46_VER6 also
419: and pact.action_status ='C'
420: and pact.report_qualifier = 'GB'
421: and pact.report_category = 'EDI'
618: /*Changes for P46_Ver6 eText End*/
619:
620: if l_arch then
621: hr_utility.set_location('Creating assignment action for ' || asg_rec.assignment_id,30);
622: select pay_assignment_actions_s.nextval
623: into l_ass_act_id
624: from dual;
625: --
626: -- insert into pay_assignment_actions.
622: select pay_assignment_actions_s.nextval
623: into l_ass_act_id
624: from dual;
625: --
626: -- insert into pay_assignment_actions.
627: hr_nonrun_asact.insact(l_ass_act_id,
628: asg_rec.assignment_id,
629: pactid,
630: chunk,
815: select /*+ ORDERED */
816: asg.assignment_id,
817: asg.effective_start_date,
818: asg.effective_end_date
819: from pay_assignment_actions paa,
820: per_assignments_f asg
821: where paa.assignment_action_id = p_assactid
822: and paa.assignment_id = asg.assignment_id
823: and p_effective_date between asg.effective_start_date and asg.effective_end_date;
827: -- Earlier code was checking run results first, then if values not found
828: -- there, then it was going for element entry values.
829: /*
830: cursor csr_max_run_result(p_element_id number) is
831: select /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
832: pact PAY_PAYROLL_ACTIONS_PK,
833: r2 PAY_RUN_RESULTS_N50)
834: USE_NL(assact2, pact, r2) */
835: /* to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type|| r2.run_result_id),17))
832: pact PAY_PAYROLL_ACTIONS_PK,
833: r2 PAY_RUN_RESULTS_N50)
834: USE_NL(assact2, pact, r2) */
835: /* to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type|| r2.run_result_id),17))
836: from pay_assignment_actions assact2,
837: pay_payroll_actions pact,
838: pay_run_results r2
839: where assact2.assignment_id = l_assignment_id
840: and r2.element_type_id+0 = p_element_id
846: and pact.effective_date between l_asg_start and l_asg_end
847: and not exists(
848: select '1'
849: from pay_action_interlocks pai,
850: pay_assignment_actions assact3,
851: pay_payroll_actions pact3
852: where pai.locked_action_id = assact2.assignment_action_id
853: and pai.locking_action_id = assact3.assignment_action_id
854: and pact3.payroll_action_id = assact3.payroll_action_id
1097: pap.national_identifier,
1098: pap.sex,
1099: fnd_date.date_to_canonical(pap.date_of_birth) date_of_birth,
1100: fnd_date.date_to_canonical(decode(pap.current_employee_flag, 'Y', serv.date_start, null)) hire_date
1101: from pay_assignment_actions act,
1102: per_assignments_f paa,
1103: per_people_f pap,
1104: per_periods_of_service serv
1105: where act.assignment_action_id = p_assactid
1111: and p_effective_date between pap.effective_start_date and pap.effective_end_date;
1112:
1113: cursor csr_job is
1114: select pay_get_job_segment_pkg.get_job_segment(paa.business_group_id,job.job_definition_id,act.payroll_action_id) job
1115: from pay_assignment_actions act,
1116: per_assignments_f paa,
1117: per_jobs job
1118: where act.assignment_action_id = p_assactid
1119: and act.assignment_id = paa.assignment_id
1568: edi_validation_fail out nocopy varchar2) IS
1569:
1570: CURSOR get_effective_date IS
1571: SELECT ppa.effective_date
1572: FROM pay_payroll_actions ppa, pay_assignment_actions paa
1573: WHERE ppa.payroll_action_id = paa.payroll_action_id
1574: AND paa.assignment_action_id = p_assactid;
1575:
1576: l_proc CONSTANT VARCHAR2(50):= g_package||'p46exp_asg_etext_validations';
1748: and addr.action_context_type = 'AAP';
1749:
1750: Cursor get_effective_date is
1751: select ppa.effective_date
1752: from pay_payroll_actions ppa, pay_assignment_actions paa
1753: where paa.payroll_action_id = ppa.payroll_action_id
1754: and paa.assignment_action_id = p_assactid;
1755:
1756: /* Modifications end here */
2055: is
2056: select 1
2057: from pay_action_information pa
2058: ,pay_payroll_actions ppa
2059: ,pay_assignment_actions paa
2060: where pa.action_information_category = 'GB P46_5 EDI'
2061: and pa.action_context_type = 'AAP'
2062: and pa.action_information4 = 'Y'
2063: and pa.assignment_id = p_person_rec.assignment_id
2828: l_title VARCHAR2(10);
2829:
2830: cursor csr_archive_type is
2831: select report_type
2832: from pay_assignment_actions paa,
2833: pay_payroll_actions ppa
2834: where paa.assignment_action_id = p_assactid
2835: and paa.payroll_action_id = ppa.payroll_action_id;
2836:
3058: --For bugs 9255173 and 9255183
3059: Cursor csr_act_actions
3060: Is
3061: Select assignment_action_id
3062: From pay_assignment_actions paa
3063: Where paa.payroll_action_id = pactid
3064: Order by assignment_action_id;
3065:
3066: Cursor messages (p_asg_act_id in number)
3227: peo.title title,
3228: paf.assignment_number emp_no,
3229: peo.national_identifier ni_no
3230: from pay_payroll_actions pay,
3231: pay_assignment_actions paa,
3232: per_all_assignments_f paf,
3233: per_all_people_f peo
3234: where pay.payroll_action_id = pactid
3235: and paa.payroll_action_id = pay.payroll_action_id
3249: upper(peo.title) title,
3250: upper(paf.assignment_number) emp_no,
3251: upper(peo.national_identifier) ni_no
3252: from pay_payroll_actions pay,
3253: pay_assignment_actions paa,
3254: per_all_assignments_f paf,
3255: per_all_people_f peo
3256: where pay.payroll_action_id = pactid
3257: and paa.payroll_action_id = pay.payroll_action_id
3413: pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
3414: /*ppa.effective_date*/
3415: sysdate
3416: from pay_payroll_actions ppa
3417: ,pay_assignment_actions paa
3418: where paa.assignment_action_id = c_assignment_action_id
3419: and ppa.payroll_action_id = paa.payroll_action_id;
3420:
3421:
3422: --For bug 8704601:Added new cursor
3423: cursor csr_parameter_info_p46_car is
3424: select ppa.effective_date
3425: from pay_payroll_actions ppa
3426: ,pay_assignment_actions paa
3427: where paa.assignment_action_id = c_assignment_action_id
3428: and ppa.payroll_action_id = paa.payroll_action_id;
3429:
3430: