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 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