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 3021: from hr_all_organization_units_vl org

3017: where business_group_id = p_business_group_id ;
3018:
3019: cursor c_org_name(p_org_id number) is
3020: select name
3021: from hr_all_organization_units_vl org
3022: where org.organization_id = p_org_id ;
3023:
3024: cursor c_pos (p_pos_id number) is
3025: select name