DBA Data[Home] [Help]

APPS.OTA_NHS_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 389: from hr_all_organization_units

385: -- cursor to check if oganization id is valid.
386: --
387: cursor csr_organization is
388: select null
389: from hr_all_organization_units
390: where organization_id = p_organization_id and
391: business_group_id = p_business_group_id;
392:
393: cursor csr_organization_cross is

Line 395: from hr_all_organization_units

391: business_group_id = p_business_group_id;
392:
393: cursor csr_organization_cross is
394: select null
395: from hr_all_organization_units
396: where organization_id = p_organization_id ;
397:
398:
399: Begin