DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 7630: hr_all_organization_units_vl orgvl

7626: SELECT a.organization_id, orgvl.name
7627: INTO X_organization_id, X_organization_name
7628: FROM per_assignments_x a,
7629: pa_all_organizations org,
7630: hr_all_organization_units_vl orgvl
7631: WHERE a.person_id = l_person_id
7632: AND a.organization_id = orgvl.organization_id
7633: AND a.organization_id = org.organization_id
7634: AND org.inactive_date is null

Line 7688: hr_all_organization_units_vl orgvl

7684: -- Get the Org
7685: SELECT b.organization_id, orgvl.name
7686: INTO X_organization_id, X_organization_name
7687: FROM bom_resources b,
7688: hr_all_organization_units_vl orgvl
7689: WHERE b.resource_id = l_bom_resource_id
7690: AND b.organization_id = orgvl.organization_id
7691: AND ROWNUM = 1;
7692: