APPS.GHR_MRE_PKG dependencies on HR_POSITIONS_F

Line 71: from hr_positions_f b

67: connect by prior subordinate_position_id = parent_position_id
68: )
69: union
70: SELECT b.position_id org_pos_id
71: from hr_positions_f b
72: WHERE b.position_id = cp_org_pos_id
73: and b.business_group_id = g_business_group_id
74: and org_pos_fl = 'P';
75:

Line 183: from hr_positions_f pop,

179: pop.ORGANIZATION_ID,
180: pop.BUSINESS_GROUP_ID,
181: punits.name ORGANIZATION_NAME,
182: pop.availability_status_id
183: from hr_positions_f pop,
184: per_organization_units punits
185: WHERE pop.business_group_id = g_business_group_id
186: and trunc(effective_DATE) between pop.effective_start_DATE and pop.effective_END_DATE
187: and pop.organization_id = punits.organization_id

Line 222: from hr_positions_f pop,

218: pop.ORGANIZATION_ID,
219: pop.BUSINESS_GROUP_ID,
220: punits.name ORGANIZATION_NAME,
221: pop.availability_status_id
222: from hr_positions_f pop,
223: per_organization_units punits
224: WHERE pop.business_group_id = g_business_group_id
225: and pop.position_id in
226: (

Line 228: from hr_positions_f

224: WHERE pop.business_group_id = g_business_group_id
225: and pop.position_id in
226: (
227: SELECT position_id POSITION_ID
228: from hr_positions_f
229: WHERE (organization_id = nvl(p_org_pos_id,organization_id) and org_pos_fl = 'O'
230: or
231: position_id = nvl(p_org_pos_id,position_id) and org_pos_fl = 'P')
232: and trunc(effective_DATE)

Line 1680: l_new_position_id hr_positions_f.position_id%TYPE;

1676: -- CREATE Option. The positions will be realigned. No 52s will be created
1677: -- and it is agreed in the design review meeting by MACROSS and JMACGOY.
1678:
1679: DECLARE
1680: l_new_position_id hr_positions_f.position_id%TYPE;
1681: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;
1682: l_pos_ei_data_rec per_position_extra_info%rowtype;
1683: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1684: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;