DBA Data[Home] [Help]

APPS.PAY_MX_RULES dependencies on HR_ORGANIZATION_INFORMATION

Line 573: ,hr_organization_information hoi

569: CURSOR c_get_employer_information(p_org_id number) IS
570: SELECT hoi.org_information1
571: ,hou.location_id
572: FROM hr_organization_units hou
573: ,hr_organization_information hoi
574: WHERE hou.organization_id = p_org_id
575: AND hoi.organization_id = hou.organization_id
576: AND hoi.org_information_context = 'MX_TAX_REGISTRATION';
577: