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_pay_basis PER_POSITION_EXTRA_INFO.POEI_INFORMATION6%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_pay_basis PER_POSITION_EXTRA_INFO.POEI_INFORMATION6%TYPE;
22: l_citizenship PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;

Line 371: HR_ALL_POSITIONS_F pp,

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

Line 427: l_pos_permanent hr_all_positions_f.permanent_temporary_flag%type;

423: and asg.assignment_type <> 'B'
424: and asg.assignment_status_type_id = ast.assignment_status_type_id
425: and ast.per_system_status = 'SUSP_ASSIGN';
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 1143: HR_ALL_POSITIONS_F pp,

1139: past.per_system_status
1140: FROM per_assignments_f pa,
1141: per_assignment_status_types past,
1142: GHR_PAYROLL gp,
1143: HR_ALL_POSITIONS_F pp,
1144: PER_POSITION_DEFINITIONS ppd,
1145: GHR_DUTY_STATIONS_F hds,
1146: HR_LOCATION_EXTRA_INFO hlei,
1147: PER_GRADES pg,

Line 1441: HR_ALL_POSITIONS_F pp,

1437:
1438: FROM GHR_SF113_V v,
1439: GHR_PA_REQUESTS gpr,
1440: GHR_NATURE_OF_ACTIONS gnoa,
1441: HR_ALL_POSITIONS_F pp,
1442: PER_POSITION_DEFINITIONS ppd,
1443: GHR_DUTY_STATIONS_F hds
1444:
1445: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1

Line 1524: HR_ALL_POSITIONS_F pp,

1520:
1521: FROM GHR_SF113_V v,
1522: GHR_PA_REQUESTS gpr,
1523: GHR_NATURE_OF_ACTIONS gnoa,
1524: HR_ALL_POSITIONS_F pp,
1525: PER_POSITION_DEFINITIONS ppd,
1526: GHR_DUTY_STATIONS_F hds
1527:
1528: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1