DBA Data[Home] [Help]

APPS.PAY_ZA_EOY_VAL dependencies on HR_ORGANIZATION_INFORMATION

Line 2016: from hr_organization_information hoi

2012: pay_za_eoy_val.modulus_10_test(hoi.org_information3) paye_ref_num_mod,
2013: upper(hoi.org_information12) sdl_ref_num, -- SDL Num (Code 2022)
2014: upper(hoi.org_information6) uif_ref_num, -- UIF Ref Num (Code 2024)
2015: hoi.org_information13 er_trade_class -- Employer Trade Classification (Code 2035)
2016: from hr_organization_information hoi
2017: where hoi.organization_id = p_legal_entity
2018: and hoi.org_information_context = 'ZA_LEGAL_ENTITY';
2019:
2020: -- Retrieve 'ZA GRE Tax File Creator Info' (Context ZA_GRE_TAX_FILE_ENTITY) from Legal Entity level

Line 2032: from hr_organization_information hoi

2028: hoi.org_information7 er_street_name_farm, -- code 2063
2029: hoi.org_information8 er_suburb_district, -- code 2063
2030: hoi.org_information9 er_town_city, -- code 2063
2031: hoi.org_information10 er_postal_code -- code 2063
2032: from hr_organization_information hoi
2033: where hoi.organization_id = p_legal_entity
2034: and hoi.org_information_context = 'ZA_GRE_TAX_FILE_ENTITY';
2035:
2036: rec_tax_info csr_tax_info%rowtype;