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.AP_APXCCOUT_XMLP_PKG dependencies on AP_EXPENSE_REPORT_HEADERS

Line 581: AP_EXPENSE_REPORT_HEADERS ERH

577: CCT.TRX_ID
578: FROM
579: AP_CREDIT_CARD_TRXNS CCT,
580: AP_CARDS_ALL AC,
581: AP_EXPENSE_REPORT_HEADERS ERH
582: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
583: AND CCT.VALIDATE_CODE = 'Y'
584: AND CCT.PAYMENT_FLAG <> 'Y'
585: AND CCT.EXPENSED_AMOUNT <> 0

Line 626: AP_EXPENSE_REPORT_HEADERS ERH

622: CCT.TRX_ID
623: FROM
624: AP_CREDIT_CARD_TRXNS CCT,
625: AP_CARDS_ALL AC,
626: AP_EXPENSE_REPORT_HEADERS ERH
627: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
628: AND CCT.VALIDATE_CODE = 'Y'
629: AND CCT.PAYMENT_FLAG <> 'Y'
630: AND CCT.EXPENSED_AMOUNT <> 0

Line 664: AP_EXPENSE_REPORT_HEADERS ERH

660: FROM
661: AP_CREDIT_CARD_TRXNS CCT,
662: AP_CARDS_ALL AC,
663: AP_EXPENSE_REPORT_LINES ERL,
664: AP_EXPENSE_REPORT_HEADERS ERH
665: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
666: AND CCT.VALIDATE_CODE = 'Y'
667: AND CCT.PAYMENT_FLAG <> 'Y'
668: AND CCT.EXPENSED_AMOUNT <> 0

Line 722: V_REPORT_HEADER_ID AP_EXPENSE_REPORT_HEADERS.REPORT_HEADER_ID%TYPE;

718: RAISE_APPLICATION_ERROR(-20101,null);
719: END SENDUNSUBMITTED;
720:
721: PROCEDURE SENDMGRUNAPPROVED IS
722: V_REPORT_HEADER_ID AP_EXPENSE_REPORT_HEADERS.REPORT_HEADER_ID%TYPE;
723: V_CURRENT_APPROVER AP_EXPENSE_REPORT_HEADERS.EXPENSE_CURRENT_APPROVER_ID%TYPE;
724: CURSOR UNAPPROVEDCHARGES IS
725: SELECT
726: DISTINCT

Line 723: V_CURRENT_APPROVER AP_EXPENSE_REPORT_HEADERS.EXPENSE_CURRENT_APPROVER_ID%TYPE;

719: END SENDUNSUBMITTED;
720:
721: PROCEDURE SENDMGRUNAPPROVED IS
722: V_REPORT_HEADER_ID AP_EXPENSE_REPORT_HEADERS.REPORT_HEADER_ID%TYPE;
723: V_CURRENT_APPROVER AP_EXPENSE_REPORT_HEADERS.EXPENSE_CURRENT_APPROVER_ID%TYPE;
724: CURSOR UNAPPROVEDCHARGES IS
725: SELECT
726: DISTINCT
727: ERH.REPORT_HEADER_ID,

Line 732: AP_EXPENSE_REPORT_HEADERS ERH

728: ERH.EXPENSE_CURRENT_APPROVER_ID
729: FROM
730: AP_CREDIT_CARD_TRXNS CCT,
731: AP_EXPENSE_REPORT_LINES ERL,
732: AP_EXPENSE_REPORT_HEADERS ERH
733: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
734: AND CCT.VALIDATE_CODE = 'Y'
735: AND CCT.PAYMENT_FLAG <> 'Y'
736: AND CCT.EXPENSED_AMOUNT <> 0

Line 777: AP_EXPENSE_REPORT_HEADERS ERH

773: ERH.EXPENSE_CURRENT_APPROVER_ID
774: FROM
775: AP_CREDIT_CARD_TRXNS CCT,
776: AP_EXPENSE_REPORT_LINES ERL,
777: AP_EXPENSE_REPORT_HEADERS ERH
778: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
779: AND CCT.VALIDATE_CODE = 'Y'
780: AND CCT.PAYMENT_FLAG <> 'Y'
781: AND CCT.EXPENSED_AMOUNT <> 0

Line 814: AP_EXPENSE_REPORT_HEADERS ERH

810: ERH.EXPENSE_CURRENT_APPROVER_ID
811: FROM
812: AP_CREDIT_CARD_TRXNS CCT,
813: AP_EXPENSE_REPORT_LINES ERL,
814: AP_EXPENSE_REPORT_HEADERS ERH
815: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
816: AND CCT.VALIDATE_CODE = 'Y'
817: AND CCT.PAYMENT_FLAG <> 'Y'
818: AND CCT.EXPENSED_AMOUNT <> 0

Line 1139: AP_EXPENSE_REPORT_HEADERS ERH

1135: AP_CREDIT_CARD_TRXNS CCT,
1136: AP_CARDS AC,
1137: AP_CARD_PROGRAMS CP,
1138: AP_EXPENSE_REPORT_LINES ERL,
1139: AP_EXPENSE_REPORT_HEADERS ERH
1140: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
1141: AND CCT.VALIDATE_CODE = 'Y'
1142: AND CCT.PAYMENT_FLAG <> 'Y'
1143: AND NVL(CCT.CATEGORY

Line 1181: AP_EXPENSE_REPORT_HEADERS_ALL ERH2

1177: AND exists (
1178: SELECT
1179: 1
1180: FROM
1181: AP_EXPENSE_REPORT_HEADERS_ALL ERH2
1182: WHERE ERH2.REPORT_HEADER_ID = CCT.REPORT_HEADER_ID
1183: OR ( CCT.REPORT_HEADER_ID is null
1184: AND NVL(CCT.EXPENSED_AMOUNT
1185: ,0) = 0 )

Line 1199: AP_EXPENSE_REPORT_HEADERS ERH

1195: AP_CREDIT_CARD_TRXNS CCT,
1196: AP_CARDS AC,
1197: AP_CARD_PROGRAMS CP,
1198: AP_EXPENSE_REPORT_LINES ERL,
1199: AP_EXPENSE_REPORT_HEADERS ERH
1200: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
1201: AND CCT.VALIDATE_CODE = 'Y'
1202: AND CCT.PAYMENT_FLAG <> 'Y'
1203: AND NVL(CCT.CATEGORY

Line 1234: AP_EXPENSE_REPORT_HEADERS_ALL ERH2

1230: AND exists (
1231: SELECT
1232: 1
1233: FROM
1234: AP_EXPENSE_REPORT_HEADERS_ALL ERH2
1235: WHERE ERH2.REPORT_HEADER_ID = CCT.REPORT_HEADER_ID
1236: OR ( CCT.REPORT_HEADER_ID is null
1237: AND NVL(CCT.EXPENSED_AMOUNT
1238: ,0) = 0 )

Line 1252: AP_EXPENSE_REPORT_HEADERS ERH

1248: AP_CREDIT_CARD_TRXNS CCT,
1249: AP_CARDS AC,
1250: AP_CARD_PROGRAMS CP,
1251: AP_EXPENSE_REPORT_LINES ERL,
1252: AP_EXPENSE_REPORT_HEADERS ERH
1253: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
1254: AND CCT.VALIDATE_CODE = 'Y'
1255: AND CCT.PAYMENT_FLAG <> 'Y'
1256: AND NVL(CCT.CATEGORY

Line 1286: AP_EXPENSE_REPORT_HEADERS_ALL ERH2

1282: AND exists (
1283: SELECT
1284: 1
1285: FROM
1286: AP_EXPENSE_REPORT_HEADERS_ALL ERH2
1287: WHERE ERH2.REPORT_HEADER_ID = CCT.REPORT_HEADER_ID
1288: OR ( CCT.REPORT_HEADER_ID is null
1289: AND NVL(CCT.EXPENSED_AMOUNT
1290: ,0) = 0 )

Line 1464: AP_EXPENSE_REPORT_HEADERS ERH

1460: AP_CARD_PROGRAMS_ALL CP,
1461: PER_PEOPLE_F PERF,
1462: PER_ASSIGNMENTS_F PERA,
1463: PER_ASSIGNMENT_STATUS_TYPES PERAS,
1464: AP_EXPENSE_REPORT_HEADERS ERH
1465: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
1466: AND CCT.PAYMENT_FLAG <> 'Y'
1467: AND CCT.EXPENSED_AMOUNT <> 0
1468: AND CCT.VALIDATE_CODE = 'Y'

Line 1552: AP_EXPENSE_REPORT_HEADERS ERH

1548: AP_CARD_PROGRAMS_ALL CP,
1549: PER_PEOPLE_F PERF,
1550: PER_ASSIGNMENTS_F PERA,
1551: PER_ASSIGNMENT_STATUS_TYPES PERAS,
1552: AP_EXPENSE_REPORT_HEADERS ERH
1553: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
1554: AND CCT.PAYMENT_FLAG <> 'Y'
1555: AND CCT.EXPENSED_AMOUNT <> 0
1556: AND CCT.VALIDATE_CODE = 'Y'