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_ASSIGNMENT_STATUS_TYPES

Line 418: per_assignment_status_types ast

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
422: and asg.primary_flag = 'Y'

Line 1129: l_pa_system_status per_assignment_status_types.per_system_status%type;

1125: l_l31d number;
1126: l_l31e number;
1127: --
1128: l_pa_effective_start_date per_all_assignments_f.effective_start_date%type;
1129: l_pa_system_status per_assignment_status_types.per_system_status%type;
1130: ---
1131:
1132: CURSOR sf113_section2 IS
1133: SELECT gp.total_salary_amount,

Line 1141: per_assignment_status_types past,

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,
1145: GHR_DUTY_STATIONS_F hds,

Line 1496: per_assignment_status_types ast

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
1500: AND asg.effective_end_date