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_PQIPED7_XMLP_PKG dependencies on PER_PAY_PROPOSALS

Line 143: PER_PAY_PROPOSALS PPP,

139: FROM PER_ALL_PEOPLE_F PEO,
140: PER_ALL_ASSIGNMENTS_F ASS,
141: PER_ASSIGNMENT_STATUS_TYPES AST,
142: PER_JOBS JOB,
143: PER_PAY_PROPOSALS PPP,
144: PER_PAY_BASES PPB,
145: HR_LOOKUPS HL
146: WHERE PEO.PERSON_ID = ASS.PERSON_ID
147: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 164: FROM PER_PAY_PROPOSALS PRO

160: AND ASS.PAY_BASIS_ID = PPB.PAY_BASIS_ID
161: AND ASS.ASSIGNMENT_ID = PPP.ASSIGNMENT_ID
162: AND PPP.CHANGE_DATE =
163: (SELECT MAX(CHANGE_DATE)
164: FROM PER_PAY_PROPOSALS PRO
165: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
166: AND PRO.CHANGE_DATE <= P_REPORT_DATE
167: AND PRO.APPROVED = 'Y' )
168: AND NVL(PPP.PROPOSED_SALARY_N, 0) * PPB.PAY_ANNUALIZATION_FACTOR > 0

Line 193: PER_PAY_PROPOSALS PPP,

189: FROM PER_ALL_PEOPLE_F PEO,
190: PER_ALL_ASSIGNMENTS_F ASS,
191: PER_ASSIGNMENT_STATUS_TYPES AST,
192: PER_JOBS JOB,
193: PER_PAY_PROPOSALS PPP,
194: PER_PAY_BASES PPB,
195: HR_LOOKUPS HL,
196: PER_PEOPLE_EXTRA_INFO PEI
197: WHERE PEO.PERSON_ID = ASS.PERSON_ID

Line 232: FROM PER_PAY_PROPOSALS PRO

228: AND ASS.PAY_BASIS_ID = PPB.PAY_BASIS_ID
229: AND ASS.ASSIGNMENT_ID = PPP.ASSIGNMENT_ID
230: AND PPP.CHANGE_DATE =
231: (SELECT MAX(CHANGE_DATE)
232: FROM PER_PAY_PROPOSALS PRO
233: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
234: AND PRO.CHANGE_DATE <= P_REPORT_DATE
235: AND PRO.APPROVED = 'Y' )
236: AND NVL(PPP.PROPOSED_SALARY_N, 0) * PPB.PAY_ANNUALIZATION_FACTOR > 0

Line 265: PER_PAY_PROPOSALS PPP,

261: FROM PER_ALL_PEOPLE_F PEO,
262: PER_ALL_ASSIGNMENTS_F ASS,
263: PER_ASSIGNMENT_STATUS_TYPES AST,
264: PER_JOBS JOB,
265: PER_PAY_PROPOSALS PPP,
266: PER_PAY_BASES PPB,
267: HR_LOOKUPS HL
268: WHERE PEO.PERSON_ID = ASS.PERSON_ID
269: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 286: FROM PER_PAY_PROPOSALS PRO

282: AND ASS.PAY_BASIS_ID = PPB.PAY_BASIS_ID
283: AND ASS.ASSIGNMENT_ID = PPP.ASSIGNMENT_ID
284: AND PPP.CHANGE_DATE =
285: (SELECT MAX(CHANGE_DATE)
286: FROM PER_PAY_PROPOSALS PRO
287: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
288: AND PRO.CHANGE_DATE <= P_REPORT_DATE
289: AND PRO.APPROVED = 'Y' )
290: AND NVL(PPP.PROPOSED_SALARY_N, 0) * PPB.PAY_ANNUALIZATION_FACTOR > 0

Line 315: PER_PAY_PROPOSALS PPP,

311: FROM PER_ALL_PEOPLE_F PEO,
312: PER_ALL_ASSIGNMENTS_F ASS,
313: PER_ASSIGNMENT_STATUS_TYPES AST,
314: PER_JOBS JOB,
315: PER_PAY_PROPOSALS PPP,
316: PER_PAY_BASES PPB,
317: HR_LOOKUPS HL,
318: PER_PEOPLE_EXTRA_INFO PEI
319: WHERE PEO.PERSON_ID = ASS.PERSON_ID

Line 354: FROM PER_PAY_PROPOSALS PRO

350: AND ASS.PAY_BASIS_ID = PPB.PAY_BASIS_ID
351: AND ASS.ASSIGNMENT_ID = PPP.ASSIGNMENT_ID
352: AND PPP.CHANGE_DATE =
353: (SELECT MAX(CHANGE_DATE)
354: FROM PER_PAY_PROPOSALS PRO
355: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
356: AND PRO.CHANGE_DATE <= P_REPORT_DATE
357: AND PRO.APPROVED = 'Y' )
358: AND NVL(PPP.PROPOSED_SALARY_N, 0) * PPB.PAY_ANNUALIZATION_FACTOR > 0