APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 501: from hr_organization_information hoi

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)
500: hoi.org_information13 er_trade_class -- Employer Trade Classification (Code 2035)
501: from hr_organization_information hoi
502: where hoi.organization_id = p_legal_entity_org
503: and hoi.org_information_context = 'ZA_LEGAL_ENTITY';
504:
505: -- Get 'ZA Tax File Information' (Context ZA_GRE_TAX_FILE_ENTITY)

Line 517: from hr_organization_information hoi

513: substr(hoi.org_information7,1,25) street_farm, -- Address : Street/Name of Farm (Code 2064)
514: substr(hoi.org_information8,1,34) suburb_district, -- Address : Suburb/District (Code 2065)
515: substr(hoi.org_information9,1,23) town_city, -- Address : Town/Cuty (Code 2066)
516: substr(hoi.org_information10,1,4) postal_code -- Address : Postal Code (Code 2080)
517: from hr_organization_information hoi
518: where hoi.organization_id = p_legal_entity_org
519: and hoi.org_information_context = 'ZA_GRE_TAX_FILE_ENTITY';
520:
521: l_proc varchar2(100) := g_package||'range_cursor';