[Home] [Help]
78: --
79: CURSOR csr_legal_representative_info(c_person_id NUMBER, c_effective_date DATE) IS
80: SELECT pap.full_name representative_name
81: ,decode(pap.per_information2, 'DNI', pap.per_information2, 'PASSPORT',pap.per_information3,NULL) dni_passport
82: FROM per_all_people_f pap
83: WHERE pap.person_id = c_person_id
84: AND c_effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date;
85: --
86:
297: PROCEDURE archive_code (p_assactid in number,
298: p_effective_date in date) IS
299:
300:
301: l_person_id per_all_people_f.person_id%type;
302: l_assignment_id per_all_assignments_f.assignment_id%type;
303: l_type VARCHAR2(1);
304: l_end_date DATE;
305:
468: ,pps.pds_information7 vacation_taken
469: ,pps.pds_information8 vacation_reamining
470: ,fnd_date.canonical_to_date(pps.pds_information9) vacation_from
471: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to
472: FROM per_all_people_f pap
473: ,per_all_assignments_f paa
474: ,per_periods_of_service pps
475: ,pay_assignment_actions paas
476: ,pay_payroll_actions ppa
516: ,pps.pds_information7 vacation_taken
517: ,pps.pds_information8 vacation_reamining
518: ,fnd_date.canonical_to_date(pps.pds_information9) vacation_from
519: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to
520: FROM per_all_people_f pap
521: ,per_all_assignments_f paa
522: ,pay_assignment_actions paas
523: ,pay_payroll_actions ppa
524: ,per_periods_of_service pps
532: AND pps.period_of_service_id (+)= paa.period_of_service_id
533: AND pap.person_id = paa.person_id
534: AND pap.person_id = pps.person_id
535: AND pap.effective_start_date = (select max(papf.effective_start_date)
536: from per_all_people_f papf
537: where papf.person_id = pap.person_id
538: AND papf.effective_start_date <= ppa.effective_date)
539: AND paa.effective_start_date = (select max(paaf.effective_start_date)
540: from per_all_assignments_f paaf