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.PER_VETS_MAG_REPORT dependencies on PER_JOBS

Line 982: per_jobs job,

978: per_people_f peo,
979: per_assignments_f ass,
980: hr_organization_information hoi1,
981: hr_organization_information hoi2,
982: per_jobs job,
983: hr_lookups hrl
984: where (pds.date_start <= p_end_date
985: and nvl(pds.actual_termination_date,hr_api.g_eot) >= p_end_date
986: or pds.date_start between p_start_date and p_end_date

Line 1061: per_jobs job,

1057: per_all_people_f peo,
1058: per_all_assignments_f ass,
1059: hr_organization_information hoi1,
1060: hr_organization_information hoi2,
1061: per_jobs job,
1062: hr_lookups hrl
1063: where
1064: pds.date_start <= p_end_date
1065: and nvl(pds.actual_termination_date,p_end_date + 1) >= p_end_date

Line 1146: per_jobs job,

1142: per_people_f peo,
1143: per_assignments_f ass,
1144: hr_organization_information hoi1,
1145: hr_organization_information hoi2,
1146: per_jobs job,
1147: hr_lookups hrl
1148: where peo.person_id = ass.person_id
1149: and peo.current_employee_flag = 'Y'
1150: and pds.date_start

Line 1220: per_jobs job,

1216: 'AFSMVIETNSDISOP',1,null)) no_nh_newly_sep_vets,
1217: decode(hrl.lookup_code,'10','1',hrl.lookup_code) lookup_code
1218: FROM per_all_people_f peo,
1219: per_all_assignments_f ass,
1220: per_jobs job,
1221: hr_lookups hrl,
1222: per_periods_of_service pps
1223: WHERE peo.person_id = ass.person_id
1224: AND peo.person_id = pps.person_id