eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_SF113_A dependencies on PER_ASSIGNMENTS_F

Line 9: l_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;

5: --
6: l_asgn_hist_data PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
7: l_people_hist_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;
8: l_pos_hist_data PER_POSITION_EXTRA_INFO%ROWTYPE;
9: l_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
10: l_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
11: l_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
12: l_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
13: l_loc_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;

Line 10: l_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

6: l_asgn_hist_data PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
7: l_people_hist_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;
8: l_pos_hist_data PER_POSITION_EXTRA_INFO%ROWTYPE;
9: l_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
10: l_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
11: l_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
12: l_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
13: l_loc_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
14: l_start_date PER_ASSIGNMENTS_F.EFFECTIVE_START_DATE%TYPE;

Line 11: l_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;

7: l_people_hist_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;
8: l_pos_hist_data PER_POSITION_EXTRA_INFO%ROWTYPE;
9: l_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
10: l_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
11: l_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
12: l_grade_id PER_ASSIGNMENTS_F.GRADE_ID%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;

Line 12: l_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;

8: l_pos_hist_data PER_POSITION_EXTRA_INFO%ROWTYPE;
9: l_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
10: l_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
11: l_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
12: l_grade_id PER_ASSIGNMENTS_F.GRADE_ID%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;

Line 13: l_loc_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;

9: l_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
10: l_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
11: l_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
12: l_grade_id PER_ASSIGNMENTS_F.GRADE_ID%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;

Line 14: l_start_date PER_ASSIGNMENTS_F.EFFECTIVE_START_DATE%TYPE;

10: l_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
11: l_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
12: l_grade_id PER_ASSIGNMENTS_F.GRADE_ID%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;

Line 15: l_end_date PER_ASSIGNMENTS_F.EFFECTIVE_END_DATE%TYPE;

11: l_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
12: l_grade_id PER_ASSIGNMENTS_F.GRADE_ID%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;

Line 417: per_assignments_f asg,

413: AND to_number(hlei.lei_information3) = hds.duty_station_id;
414: ---
415: Cursor chk_susp_asg_status is
416: select 'X' from
417: per_assignments_f asg,
418: per_assignment_status_types ast
419: where asg.assignment_id = l_assignment_id
420: and p_empl_as_of_date between asg.effective_start_date
421: and asg.effective_end_date

Line 1140: FROM per_assignments_f pa,

1136: hds.msa_code,
1137: pp.position_id,
1138: pa.effective_start_date,
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,

Line 1495: FROM per_assignments_f asg,

1491: -- Bug 3264666 Anil
1492:
1493: CURSOR chk_susp_asg_status is
1494: SELECT 'X'
1495: FROM per_assignments_f asg,
1496: per_assignment_status_types ast
1497:
1498: WHERE asg.assignment_id = l_assignment_id
1499: AND p_empl_as_of_date between asg.effective_start_date