APPS.GHR_SF113_A dependencies on HR_ALL_POSITIONS_F

Line 17: l_date_end HR_ALL_POSITIONS_F.DATE_END%TYPE;

13: l_loc_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
14: l_start_date PER_ASSIGNMENTS_F.EFFECTIVE_START_DATE%TYPE;
15: l_end_date PER_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE;
16: l_tenure PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION4%TYPE;
17: l_date_end HR_ALL_POSITIONS_F.DATE_END%TYPE;
18: l_date_effective HR_ALL_POSITIONS_F.DATE_END%TYPE;
19: l_work_schedule PER_POSITION_EXTRA_INFO. POEI_INFORMATION10%TYPE;
20: l_position_code PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%TYPE;
21: l_citizenship PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;

Line 18: l_date_effective HR_ALL_POSITIONS_F.DATE_END%TYPE;

14: l_start_date PER_ASSIGNMENTS_F.EFFECTIVE_START_DATE%TYPE;
15: l_end_date PER_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE;
16: l_tenure PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION4%TYPE;
17: l_date_end HR_ALL_POSITIONS_F.DATE_END%TYPE;
18: l_date_effective HR_ALL_POSITIONS_F.DATE_END%TYPE;
19: l_work_schedule PER_POSITION_EXTRA_INFO. POEI_INFORMATION10%TYPE;
20: l_position_code PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%TYPE;
21: l_citizenship PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
22: l_appointment PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;

Line 370: HR_ALL_POSITIONS_F pp,

366: FROM GHR_SF113_V v,
367: GHR_DUTY_STATIONS_F hds,
368: HR_LOCATION_EXTRA_INFO hlei,
369: PER_POSITION_DEFINITIONS ppd,
370: HR_ALL_POSITIONS_F pp,
371: PER_GRADES pg,
372: PER_GRADE_DEFINITIONS pgd
373: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
374: ,'SEGMENT2',ppd.segment2

Line 427: l_pos_permanent hr_all_positions_f.permanent_temporary_flag%type;

423: and asg.assignment_status_type_id = ast.assignment_status_type_id
424: and ast.per_system_status = 'SUSP_ASSIGN';
425:
426: --
427: l_pos_permanent hr_all_positions_f.permanent_temporary_flag%type;
428:
429: BEGIN
430: -- NOCOPY changes
431: l_l1a := p_l1a;

Line 1133: HR_ALL_POSITIONS_F pp,

1129: past.per_system_status
1130: FROM per_assignments_f pa,
1131: per_assignment_status_types past,
1132: GHR_PAYROLL gp,
1133: HR_ALL_POSITIONS_F pp,
1134: PER_POSITION_DEFINITIONS ppd,
1135: GHR_DUTY_STATIONS_F hds,
1136: HR_LOCATION_EXTRA_INFO hlei,
1137: PER_GRADES pg,

Line 1431: HR_ALL_POSITIONS_F pp,

1427:
1428: FROM GHR_SF113_V v,
1429: GHR_PA_REQUESTS gpr,
1430: GHR_NATURE_OF_ACTIONS gnoa,
1431: HR_ALL_POSITIONS_F pp,
1432: PER_POSITION_DEFINITIONS ppd,
1433: GHR_DUTY_STATIONS_F hds
1434:
1435: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1

Line 1514: HR_ALL_POSITIONS_F pp,

1510:
1511: FROM GHR_SF113_V v,
1512: GHR_PA_REQUESTS gpr,
1513: GHR_NATURE_OF_ACTIONS gnoa,
1514: HR_ALL_POSITIONS_F pp,
1515: PER_POSITION_DEFINITIONS ppd,
1516: GHR_DUTY_STATIONS_F hds
1517:
1518: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1