DBA Data[Home] [Help]

APPS.PQH_PQIPED5_XMLP_PKG dependencies on PER_PAY_PROPOSALS

Line 352: PER_PAY_PROPOSALS PPP,

348: PER_ALL_PEOPLE_F PEO,
349: PER_ALL_ASSIGNMENTS_F ASS,
350: PER_ASSIGNMENT_STATUS_TYPES AST,
351: PER_CONTRACTS_F PCO,
352: PER_PAY_PROPOSALS PPP,
353: PER_PAY_BASES PPB,
354: HR_LOOKUPS HL,
355: PER_JOBS JOB,
356: PER_SHARED_TYPES PST,

Line 372: PER_PAY_PROPOSALS PRO

368: AND PPP.CHANGE_DATE = (
369: SELECT
370: MAX(CHANGE_DATE)
371: FROM
372: PER_PAY_PROPOSALS PRO
373: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
374: AND PRO.CHANGE_DATE <= P_REPORT_DATE
375: AND PRO.APPROVED = 'Y' )
376: AND NVL(PPP.PROPOSED_SALARY_N

Line 533: PER_PAY_PROPOSALS PPP,

529: PER_ALL_PEOPLE_F PEO,
530: PER_ALL_ASSIGNMENTS_F ASS,
531: PER_ASSIGNMENT_STATUS_TYPES AST,
532: PER_CONTRACTS_F PCO,
533: PER_PAY_PROPOSALS PPP,
534: PER_PAY_BASES PPB,
535: HR_LOOKUPS HL,
536: PER_JOBS JOB,
537: PER_SHARED_TYPES PST,

Line 577: PER_PAY_PROPOSALS PRO

573: AND PPP.CHANGE_DATE = (
574: SELECT
575: MAX(CHANGE_DATE)
576: FROM
577: PER_PAY_PROPOSALS PRO
578: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
579: AND PRO.CHANGE_DATE <= P_REPORT_DATE
580: AND PRO.APPROVED = 'Y' )
581: AND NVL(PPP.PROPOSED_SALARY_N

Line 791: PER_PAY_PROPOSALS PPP,

787: PER_ALL_PEOPLE_F PEO,
788: PER_ALL_ASSIGNMENTS_F ASS,
789: PER_ASSIGNMENT_STATUS_TYPES AST,
790: PER_CONTRACTS_F PCO,
791: PER_PAY_PROPOSALS PPP,
792: PER_PAY_BASES PPB,
793: HR_LOOKUPS HL,
794: PER_JOBS JOB,
795: PER_SHARED_TYPES PST,

Line 811: PER_PAY_PROPOSALS PRO

807: AND PPP.CHANGE_DATE = (
808: SELECT
809: MAX(CHANGE_DATE)
810: FROM
811: PER_PAY_PROPOSALS PRO
812: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
813: AND PRO.CHANGE_DATE <= P_REPORT_DATE
814: AND PRO.APPROVED = 'Y' )
815: AND NVL(PPP.PROPOSED_SALARY_N

Line 963: PER_PAY_PROPOSALS PPP,

959: PER_ALL_PEOPLE_F PEO,
960: PER_ALL_ASSIGNMENTS_F ASS,
961: PER_ASSIGNMENT_STATUS_TYPES AST,
962: PER_CONTRACTS_F PCO,
963: PER_PAY_PROPOSALS PPP,
964: PER_PAY_BASES PPB,
965: HR_LOOKUPS HL,
966: PER_JOBS JOB,
967: PER_SHARED_TYPES PST,

Line 1007: PER_PAY_PROPOSALS PRO

1003: AND PPP.CHANGE_DATE = (
1004: SELECT
1005: MAX(CHANGE_DATE)
1006: FROM
1007: PER_PAY_PROPOSALS PRO
1008: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
1009: AND PRO.CHANGE_DATE <= P_REPORT_DATE
1010: AND PRO.APPROVED = 'Y' )
1011: AND NVL(PPP.PROPOSED_SALARY_N