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
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