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

292: pop.ORGANIZATION_ID,
293: pop.BUSINESS_GROUP_ID,
294: punits.name ORGANIZATION_NAME,
295: pop.availability_status_id
296: from hr_positions_f pop,
297: per_organization_units punits
298: where pop.position_id in
299: (
300: select position_id POSITION_ID

Line 301: from hr_positions_f

297: per_organization_units punits
298: where pop.position_id in
299: (
300: select position_id POSITION_ID
301: from hr_positions_f
302: where (organization_id = nvl(p_org_id,organization_id) and org_pos_fl = 'O'
303: or position_id = nvl(p_org_id,position_id) and org_pos_fl = 'P')
304: and trunc(effective_date) between
305: effective_start_date and effective_end_date

Line 487: l_avail_status_id hr_positions_f.availability_status_id%type;

483: l_first_action_la_code2 varchar2(30);
484:
485: l_remark_code1 varchar2(30);
486: l_remark_code2 varchar2(30);
487: l_avail_status_id hr_positions_f.availability_status_id%type;
488: --
489:
490: REC_BUSY exception;
491: pragma exception_init(REC_BUSY,-54);

Line 1341: l_position_id hr_positions_f.position_id%TYPE;

1337: -- No 52s will be created
1338: -- and it is agreed in the design review meeting by MACROSS and JMACGOY.
1339: DECLARE
1340:
1341: l_position_id hr_positions_f.position_id%TYPE;
1342: l_position_data_rec ghr_sf52_pos_update.position_data_rec_type;
1343:
1344: BEGIN
1345: l_avail_status_id := NULL;