[Home] [Help]
234: 'select distinct paf.person_id
235: from per_assignments_f paf,
236: pay_payrolls_f ppf,
237: pay_payroll_actions ppa ,
238: per_assignment_extra_info aei
239: where ppa.payroll_action_id = :payroll_action_id
240: and paf.business_group_id = ppa.business_group_id
241: and paf.assignment_type = ''E''
242: and ppf.payroll_id = paf.payroll_id
419: from per_all_people_f ppf
420: , per_all_assignments_f paa
421: , pay_payroll_actions ppa
422: , per_periods_of_service pps
423: , per_assignment_extra_info aei
424: where ppf.person_id between p_stperson and p_endperson
425: and paa.person_id = ppf.person_id
426: and paa.business_group_id = ppa.business_group_id
427: and ppa.payroll_action_id = p_pactid
654: 'P','Permanent',
655: 'N','Non-Permanent'),
656: per_za_employment_equity_pkg.get_ee_employment_type_name(p_effective_date
657: , p_period_of_service_id))) EMP201_status
658: from per_assignment_extra_info aei
659: where aei.assignment_id = p_assignment_id
660: and aei.information_type = 'ZA_SPECIFIC_INFO' ;
661:
662: --Retrieve the employee's UIF Information
661:
662: --Retrieve the employee's UIF Information
663: cursor csr_asg_uif_info_dtls (p_assignment_id number) is
664: select aei.aei_information1 reason_for_non_contrib
665: from per_assignment_extra_info aei
666: where aei.assignment_id = p_assignment_id
667: and aei.information_type = 'ZA_UIF_INFO' ;
668:
669: -- select the payroll_action_id of the last payroll run
703: , p_effective_date date) is
704: select decode(hoi.org_information1,'Exempt','E',nvl(aei.aei_information9,'N')) "Exemption"
705: from per_all_assignments_f ass
706: , hr_organization_information hoi
707: , per_assignment_extra_info aei
708: where ass.assignment_id = p_assignment_id
709: and p_effective_date between ass.effective_start_date and ass.effective_end_date
710: and ass.organization_id = hoi.organization_id
711: and hoi.org_information_context = 'ZA_NQF_SETA_INFO'