DBA Data[Home] [Help]

APPS.AP_APXCCOUT_XMLP_PKG dependencies on AP_EXPENSE_REPORT_LINES

Line 663: AP_EXPENSE_REPORT_LINES ERL,

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'

Line 731: AP_EXPENSE_REPORT_LINES ERL,

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'

Line 776: AP_EXPENSE_REPORT_LINES ERL,

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'

Line 813: AP_EXPENSE_REPORT_LINES ERL,

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'

Line 1138: AP_EXPENSE_REPORT_LINES ERL,

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'

Line 1198: AP_EXPENSE_REPORT_LINES ERL,

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'

Line 1251: AP_EXPENSE_REPORT_LINES ERL,

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'