APPS.BEN_EXT_PERSON dependencies on HR_ALL_ORGANIZATION_UNITS

Line 927: from hr_all_organization_units

923:
924:
925: cursor c_org is
926: select location_id
927: from hr_all_organization_units
928: where organization_id = p_org_id ;
929:
930: l_location_id Hr_locations_all.location_id%Type ;
931:

Line 1116: hr_all_organization_units_vl o,

1112: a.supervisor_id ,
1113: a.assignment_type,
1114: b.pay_basis
1115: from per_all_assignments_f a,
1116: hr_all_organization_units_vl o,
1117: per_assignment_status_types s,
1118: pay_people_groups grp,
1119: per_pay_bases b
1120: where

Line 3055: from hr_all_organization_units_vl org

3051: where business_group_id = p_business_group_id ;
3052:
3053: cursor c_org_name(p_org_id number) is
3054: select name
3055: from hr_all_organization_units_vl org
3056: where org.organization_id = p_org_id ;
3057:
3058: cursor c_pos (p_pos_id number) is
3059: select name