DBA Data[Home] [Help]

APPS.PAY_CA_RL2_REG dependencies on HR_ORGANIZATION_INFORMATION

Line 221: from hr_organization_information hoi,

217:
218:
219: cursor c_first_tax_unit_id (l_pre_org_id varchar2) is
220: select distinct hoi.organization_id
221: from hr_organization_information hoi,
222: hr_all_organization_units hou
223: where hou.business_group_id = l_bus_group_id
224: and hou.organization_id = hoi.organization_id
225: and hoi.org_information_context = 'Canada Employer Identification'