659: CCT.TRX_ID
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'
727: ERH.REPORT_HEADER_ID,
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'
772: ERH.REPORT_HEADER_ID,
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'
809: ERH.REPORT_HEADER_ID,
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'
1134: FROM
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'
1194: FROM
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'
1247: FROM
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'