APPS.PAY_CA_RL1_REG dependencies on HR_ORGANIZATION_INFORMATION

Line 276: from hr_organization_information hoi

272: and paa.assignment_id = cp_assignment_id;
273:
274: cursor c_first_tax_unit_id (p_pre_org_id varchar2) is
275: select distinct organization_id
276: from hr_organization_information hoi
277: where hoi.org_information_context = 'Canada Employer Identification'
278: and hoi.org_information2 = p_pre_org_id;
279:
280: /* 11510 Change to fix bug#3356512, modified cursor c_all_asg */