[Home] [Help]
491: procedure range_cursor (pactid in number,
492: sqlstr out nocopy varchar2) as
493:
494: -- Get 'ZA Tax Information' (Context ZA_LEGAL_ENTITY)
495: cursor csr_tax_info (p_legal_entity_org hr_all_organization_units.organization_id%type)is
496: select substr(hoi.org_information1, 1, 90) er_trade_name, -- Employer Trading or Other Name (Code 2010)
497: hoi.org_information3 paye_ref_num, -- PAYE Ref Num (Code 2020)
498: upper(hoi.org_information6) uif_ref_num, -- UIF Ref Num (Code 2024)
499: upper(hoi.org_information12) sdl_ref_num, -- UIF Ref Num (Code 2024)
729: "the Tax year (and for which processing took place), whenever the TYE Archiver SRS
730: "is run for each of those legal entities.
731: */
732:
733: cursor get_asg( p_legal_entity hr_all_organization_units.organization_id%TYPE
734: , p_payroll_id pay_all_payrolls_f.payroll_id%TYPE
735: , p_tax_year varchar2
736: , p_itreg_batch varchar2
737: , p_period_recon varchar2
2631: , nvl(a.location_id, nvl(pap.location_id, haou.location_id)) location_id
2632: from per_all_people_f ppf
2633: , per_all_assignments_f a
2634: , per_all_positions pap
2635: , hr_all_organization_units haou
2636: where a.assignment_id = p_assignment_id
2637: and ppf.person_id = a.person_id
2638: and l_effective_date between a.effective_start_date and a.effective_end_date
2639: and l_effective_date between ppf.effective_start_date and ppf.effective_end_date