DBA Data[Home] [Help]

APPS.PAY_CA_RL1_REG dependencies on HR_ORGANIZATION_INFORMATION

Line 302: from hr_organization_information hoi

298: and paa.assignment_id = cp_assignment_id;
299:
300: cursor c_first_tax_unit_id (p_pre_org_id varchar2) is
301: select distinct organization_id
302: from hr_organization_information hoi
303: where hoi.org_information_context = 'Canada Employer Identification'
304: and hoi.org_information2 = p_pre_org_id;
305:
306: /* 11510 Change to fix bug#3356512, modified cursor c_all_asg */