DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 7788: hr_all_organization_units_vl orgvl

7784: SELECT a.organization_id, orgvl.name
7785: INTO X_organization_id, X_organization_name
7786: FROM per_assignments_x a,
7787: pa_all_organizations org,
7788: hr_all_organization_units_vl orgvl
7789: WHERE a.person_id = l_person_id
7790: AND a.organization_id = orgvl.organization_id
7791: AND a.organization_id = org.organization_id
7792: AND org.inactive_date is null

Line 7846: hr_all_organization_units_vl orgvl

7842: -- Get the Org
7843: SELECT b.organization_id, orgvl.name
7844: INTO X_organization_id, X_organization_name
7845: FROM bom_resources b,
7846: hr_all_organization_units_vl orgvl
7847: WHERE b.resource_id = l_bom_resource_id
7848: AND b.organization_id = orgvl.organization_id
7849: AND ROWNUM = 1;
7850: