APPS.CS_SR_INTERFACE_CP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 590: FROM hr_all_organization_units --need to clarify whether to use hr_organization_units

586:
587: BEGIN
588: SELECT name
589: INTO l_organization_name
590: FROM hr_all_organization_units --need to clarify whether to use hr_organization_units
591: WHERE organization_id = (select expenditure_org_id from cs_estimate_details where estimate_detail_id =l_estimate_detail_id );
592:
593: Exception
594: WHEN TOO_MANY_ROWS THEN

Line 1372: from hr_all_organization_units

1368:
1369:
1370: Select name into
1371: l_business_group_name
1372: from hr_all_organization_units
1373: where organization_id =l_business_group_id and rownum=1;
1374:
1375:
1376: Exception