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 177: from hr_positions_f pop,

173: pop.ORGANIZATION_ID,
174: pop.BUSINESS_GROUP_ID,
175: punits.name ORGANIZATION_NAME,
176: pop.availability_status_id
177: from hr_positions_f pop,
178: per_organization_units punits
179: WHERE pop.business_group_id = g_business_group_id
180: and trunc(effective_DATE) between pop.effective_start_DATE and pop.effective_END_DATE
181: and pop.organization_id = punits.organization_id

Line 216: from hr_positions_f pop,

212: pop.ORGANIZATION_ID,
213: pop.BUSINESS_GROUP_ID,
214: punits.name ORGANIZATION_NAME,
215: pop.availability_status_id
216: from hr_positions_f pop,
217: per_organization_units punits
218: WHERE pop.business_group_id = g_business_group_id
219: and pop.position_id in
220: (

Line 222: from hr_positions_f

218: WHERE pop.business_group_id = g_business_group_id
219: and pop.position_id in
220: (
221: SELECT position_id POSITION_ID
222: from hr_positions_f
223: WHERE (organization_id = nvl(p_org_pos_id,organization_id) and org_pos_fl = 'O'
224: or
225: position_id = nvl(p_org_pos_id,position_id) and org_pos_fl = 'P')
226: and trunc(effective_DATE)

Line 1649: l_new_position_id hr_positions_f.position_id%TYPE;

1645: -- and it is agreed in the design review meeting by MACROSS and JMACGOY.
1646:
1647: DECLARE
1648:
1649: l_new_position_id hr_positions_f.position_id%TYPE;
1650: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;
1651:
1652: l_pos_ei_data_rec per_position_extra_info%rowtype;
1653: l_new_pos_grp1_rec per_position_extra_info%rowtype;