DBA Data[Home] [Help]

APPS.PQH_PQIPED5_XMLP_PKG dependencies on PER_PAY_PROPOSALS

Line 574: PER_PAY_PROPOSALS PPP,

570: PER_ALL_PEOPLE_F PEO,
571: PER_ALL_ASSIGNMENTS_F ASS,
572: PER_ASSIGNMENT_STATUS_TYPES AST,
573: PER_CONTRACTS_F PCO,
574: PER_PAY_PROPOSALS PPP,
575: PER_PAY_BASES PPB,
576: HR_LOOKUPS HL,
577: PER_JOBS JOB,
578: PER_SHARED_TYPES PST,

Line 594: PER_PAY_PROPOSALS PRO

590: AND PPP.CHANGE_DATE = (
591: SELECT
592: MAX(CHANGE_DATE)
593: FROM
594: PER_PAY_PROPOSALS PRO
595: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
596: AND PRO.CHANGE_DATE <= P_REPORT_DATE
597: AND PRO.APPROVED = 'Y' )
598: AND NVL(PPP.PROPOSED_SALARY_N

Line 757: PER_PAY_PROPOSALS PPP,

753: PER_ALL_PEOPLE_F PEO,
754: PER_ALL_ASSIGNMENTS_F ASS,
755: PER_ASSIGNMENT_STATUS_TYPES AST,
756: PER_CONTRACTS_F PCO,
757: PER_PAY_PROPOSALS PPP,
758: PER_PAY_BASES PPB,
759: HR_LOOKUPS HL,
760: PER_JOBS JOB,
761: PER_SHARED_TYPES PST,

Line 801: PER_PAY_PROPOSALS PRO

797: AND PPP.CHANGE_DATE = (
798: SELECT
799: MAX(CHANGE_DATE)
800: FROM
801: PER_PAY_PROPOSALS PRO
802: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
803: AND PRO.CHANGE_DATE <= P_REPORT_DATE
804: AND PRO.APPROVED = 'Y' )
805: AND NVL(PPP.PROPOSED_SALARY_N

Line 1209: PER_PAY_PROPOSALS PPP,

1205: PER_ALL_PEOPLE_F PEO,
1206: PER_ALL_ASSIGNMENTS_F ASS,
1207: PER_ASSIGNMENT_STATUS_TYPES AST,
1208: PER_CONTRACTS_F PCO,
1209: PER_PAY_PROPOSALS PPP,
1210: PER_PAY_BASES PPB,
1211: HR_LOOKUPS HL,
1212: PER_JOBS JOB,
1213: PER_SHARED_TYPES PST,

Line 1229: PER_PAY_PROPOSALS PRO

1225: AND PPP.CHANGE_DATE = (
1226: SELECT
1227: MAX(CHANGE_DATE)
1228: FROM
1229: PER_PAY_PROPOSALS PRO
1230: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
1231: AND PRO.CHANGE_DATE <= P_REPORT_DATE
1232: AND PRO.APPROVED = 'Y' )
1233: AND NVL(PPP.PROPOSED_SALARY_N

Line 1384: PER_PAY_PROPOSALS PPP,

1380: PER_ALL_PEOPLE_F PEO,
1381: PER_ALL_ASSIGNMENTS_F ASS,
1382: PER_ASSIGNMENT_STATUS_TYPES AST,
1383: PER_CONTRACTS_F PCO,
1384: PER_PAY_PROPOSALS PPP,
1385: PER_PAY_BASES PPB,
1386: HR_LOOKUPS HL,
1387: PER_JOBS JOB,
1388: PER_SHARED_TYPES PST,

Line 1428: PER_PAY_PROPOSALS PRO

1424: AND PPP.CHANGE_DATE = (
1425: SELECT
1426: MAX(CHANGE_DATE)
1427: FROM
1428: PER_PAY_PROPOSALS PRO
1429: WHERE PPP.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
1430: AND PRO.CHANGE_DATE <= P_REPORT_DATE
1431: AND PRO.APPROVED = 'Y' )
1432: AND NVL(PPP.PROPOSED_SALARY_N