DBA Data[Home] [Help]

APPS.PAY_ZA_TAX_REG_AR dependencies on HR_ORGANIZATION_INFORMATION

Line 482: hr_organization_information hoi,

478:
479: CURSOR get_legal_entity_name(p_organization_id number)IS
480: select haou.name
481: from hr_all_organization_units haou,
482: hr_organization_information hoi,
483: hr_organization_information hoi2
484: where haou.organization_id = p_organization_id
485: and hoi.organization_id = haou.organization_id
486: and hoi.org_information_context = 'ZA_LEGAL_ENTITY'

Line 483: hr_organization_information hoi2

479: CURSOR get_legal_entity_name(p_organization_id number)IS
480: select haou.name
481: from hr_all_organization_units haou,
482: hr_organization_information hoi,
483: hr_organization_information hoi2
484: where haou.organization_id = p_organization_id
485: and hoi.organization_id = haou.organization_id
486: and hoi.org_information_context = 'ZA_LEGAL_ENTITY'
487: and hoi2.organization_id = haou.organization_id