DBA Data[Home] [Help]

APPS.PQH_PQIPED10_XMLP_PKG dependencies on PER_PAY_PROPOSALS

Line 286: PER_PAY_PROPOSALS PPP,

282: PER_ALL_PEOPLE_F PEO,
283: PER_ALL_ASSIGNMENTS_F ASS,
284: PER_ASSIGNMENT_STATUS_TYPES AST,
285: PER_JOBS JOB,
286: PER_PAY_PROPOSALS PPP,
287: PER_PAY_BASES PPB,
288: HR_LOOKUPS HL
289: WHERE PEO.PERSON_ID = ASS.PERSON_ID
290: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 313: PER_PAY_PROPOSALS PRO

309: AND PPP.CHANGE_DATE = (
310: SELECT
311: MAX(CHANGE_DATE)
312: FROM
313: PER_PAY_PROPOSALS PRO
314: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
315: AND PRO.CHANGE_DATE <= P_REPORT_DATE
316: AND PRO.APPROVED = 'Y' )
317: AND NVL(PPP.PROPOSED_SALARY_N

Line 440: PER_PAY_PROPOSALS PPP,

436: PER_ALL_PEOPLE_F PEO,
437: PER_ALL_ASSIGNMENTS_F ASS,
438: PER_ASSIGNMENT_STATUS_TYPES AST,
439: PER_JOBS JOB,
440: PER_PAY_PROPOSALS PPP,
441: PER_PAY_BASES PPB,
442: HR_LOOKUPS HL,
443: PER_PEOPLE_EXTRA_INFO PEI
444: WHERE PEO.PERSON_ID = ASS.PERSON_ID

Line 491: PER_PAY_PROPOSALS PRO

487: AND PPP.CHANGE_DATE = (
488: SELECT
489: MAX(CHANGE_DATE)
490: FROM
491: PER_PAY_PROPOSALS PRO
492: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
493: AND PRO.CHANGE_DATE <= P_REPORT_DATE
494: AND PRO.APPROVED = 'Y' )
495: AND NVL(PPP.PROPOSED_SALARY_N

Line 671: PER_PAY_PROPOSALS PPP,

667: PER_ALL_PEOPLE_F PEO,
668: PER_ALL_ASSIGNMENTS_F ASS,
669: PER_ASSIGNMENT_STATUS_TYPES AST,
670: PER_JOBS JOB,
671: PER_PAY_PROPOSALS PPP,
672: PER_PAY_BASES PPB,
673: HR_LOOKUPS HL
674: WHERE PEO.PERSON_ID = ASS.PERSON_ID
675: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 698: PER_PAY_PROPOSALS PRO

694: AND PPP.CHANGE_DATE = (
695: SELECT
696: MAX(CHANGE_DATE)
697: FROM
698: PER_PAY_PROPOSALS PRO
699: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
700: AND PRO.CHANGE_DATE <= P_REPORT_DATE
701: AND PRO.APPROVED = 'Y' )
702: AND NVL(PPP.PROPOSED_SALARY_N

Line 823: PER_PAY_PROPOSALS PPP,

819: PER_ALL_PEOPLE_F PEO,
820: PER_ALL_ASSIGNMENTS_F ASS,
821: PER_ASSIGNMENT_STATUS_TYPES AST,
822: PER_JOBS JOB,
823: PER_PAY_PROPOSALS PPP,
824: PER_PAY_BASES PPB,
825: HR_LOOKUPS HL,
826: PER_PEOPLE_EXTRA_INFO PEI
827: WHERE PEO.PERSON_ID = ASS.PERSON_ID

Line 874: PER_PAY_PROPOSALS PRO

870: AND PPP.CHANGE_DATE = (
871: SELECT
872: MAX(CHANGE_DATE)
873: FROM
874: PER_PAY_PROPOSALS PRO
875: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
876: AND PRO.CHANGE_DATE <= P_REPORT_DATE
877: AND PRO.APPROVED = 'Y' )
878: AND NVL(PPP.PROPOSED_SALARY_N