APPS.GHR_MTO_PKG dependencies on HR_POSITIONS_F

Line 195: from hr_positions_f b

191: connect by prior subordinate_position_id = parent_position_id
192: )
193: union
194: select b.position_id org_pos_id
195: from hr_positions_f b
196: where b.position_id = cp_orgid
197: and org_pos_fl = 'P';
198:
199: /* and child_fl = 'N';*/

Line 315: from hr_positions_f pop,

311: pop.ORGANIZATION_ID,
312: pop.BUSINESS_GROUP_ID,
313: punits.name ORGANIZATION_NAME,
314: pop.availability_status_id
315: from hr_positions_f pop,
316: per_organization_units punits
317: where pop.position_id in
318: (
319: select position_id POSITION_ID

Line 320: from hr_positions_f

316: per_organization_units punits
317: where pop.position_id in
318: (
319: select position_id POSITION_ID
320: from hr_positions_f
321: where (organization_id = nvl(p_org_id,organization_id) and org_pos_fl = 'O'
322: or position_id = nvl(p_org_id,position_id) and org_pos_fl = 'P')
323: and trunc(effective_date) between
324: effective_start_date and effective_end_date

Line 513: l_avail_status_id hr_positions_f.availability_status_id%type;

509: l_first_action_la_code2 varchar2(30);
510:
511: l_remark_code1 varchar2(30);
512: l_remark_code2 varchar2(30);
513: l_avail_status_id hr_positions_f.availability_status_id%type;
514: --
515:
516: REC_BUSY exception;
517: pragma exception_init(REC_BUSY,-54);

Line 1438: l_position_id hr_positions_f.position_id%TYPE;

1434: -- No 52s will be created
1435: -- and it is agreed in the design review meeting by MACROSS and JMACGOY.
1436: DECLARE
1437:
1438: l_position_id hr_positions_f.position_id%TYPE;
1439: l_position_data_rec ghr_sf52_pos_update.position_data_rec_type;
1440:
1441: BEGIN
1442: l_avail_status_id := NULL;