DBA Data[Home] [Help]

APPS.PAY_CA_RL2_REG dependencies on HR_ORGANIZATION_INFORMATION

Line 180: from hr_organization_information hoi,

176:
177:
178: cursor c_first_tax_unit_id (l_pre_org_id varchar2) is
179: select distinct hoi.organization_id
180: from hr_organization_information hoi,
181: hr_all_organization_units hou
182: where hou.business_group_id = l_bus_group_id
183: and hou.organization_id = hoi.organization_id
184: and hoi.org_information_context = 'Canada Employer Identification'