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 417: per_assignment_status_types ast

413: ---
414: Cursor chk_susp_asg_status is
415: select 'X' from
416: per_assignments_f asg,
417: per_assignment_status_types ast
418: where asg.assignment_id = l_assignment_id
419: and p_empl_as_of_date between asg.effective_start_date
420: and asg.effective_end_date
421: and asg.primary_flag = 'Y'

Line 1119: l_pa_system_status per_assignment_status_types.per_system_status%type;

1115: l_l31d number;
1116: l_l31e number;
1117: --
1118: l_pa_effective_start_date per_all_assignments_f.effective_start_date%type;
1119: l_pa_system_status per_assignment_status_types.per_system_status%type;
1120: ---
1121:
1122: CURSOR sf113_section2 IS
1123: SELECT gp.total_salary_amount,

Line 1131: per_assignment_status_types past,

1127: pp.position_id,
1128: pa.effective_start_date,
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,

Line 1486: per_assignment_status_types ast

1482:
1483: CURSOR chk_susp_asg_status is
1484: SELECT 'X'
1485: FROM per_assignments_f asg,
1486: per_assignment_status_types ast
1487:
1488: WHERE asg.assignment_id = l_assignment_id
1489: AND p_empl_as_of_date between asg.effective_start_date
1490: AND asg.effective_end_date