DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on HR_ALL_ORGANIZATION_UNITS_VL

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