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.PQH_PQIPED6_XMLP_PKG dependencies on PER_PAY_PROPOSALS

Line 163: per_pay_proposals ppp,

159: FROM per_all_people_f peo,
160: per_all_assignments_f ass,
161: per_assignment_status_types ast,
162: per_jobs job,
163: per_pay_proposals ppp,
164: per_pay_bases ppb,
165: hr_lookups hl
166: WHERE peo.person_id = ass.person_id
167: AND peo.current_employee_flag = 'Y'

Line 173: FROM per_pay_proposals PRO

169: AND job.job_information8 NOT IN('1', '2', '3', '4')
170: AND pqh_employment_category.identify_empl_category(ass.employment_category, cp_fr, cp_ft, cp_pr, cp_pt) IN('FR')
171: AND ppp.change_date =
172: (SELECT MAX(change_date)
173: FROM per_pay_proposals PRO
174: WHERE ppp.assignment_id = PRO.ASSIGNMENT_ID
175: AND PRO.CHANGE_DATE <= P_REPORT_DATE
176: AND PRO.APPROVED = 'Y' )
177: AND ass.pay_basis_id = ppb.pay_basis_id

Line 219: per_pay_proposals ppp,

215: FROM per_all_people_f peo,
216: per_all_assignments_f ass,
217: per_assignment_status_types ast,
218: per_jobs job,
219: per_pay_proposals ppp,
220: per_pay_bases ppb,
221: hr_lookups hl,
222: per_people_extra_info pei
223: WHERE peo.person_id = ass.person_id

Line 247: FROM per_pay_proposals PRO

243: AND job.job_information8 NOT IN('1', '2', '3', '4')
244: AND pqh_employment_category.identify_empl_category(ass.employment_category, cp_fr, cp_ft, cp_pr, cp_pt) IN('FR')
245: AND ppp.change_date =
246: (SELECT MAX(change_date)
247: FROM per_pay_proposals PRO
248: WHERE ppp.assignment_id = PRO.ASSIGNMENT_ID
249: AND PRO.CHANGE_DATE <= P_REPORT_DATE
250: AND PRO.APPROVED = 'Y' )
251: AND ass.pay_basis_id = ppb.pay_basis_id