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_WEB_DB_CCARD_PKG dependencies on AP_CARDS_ALL

Line 198: ap_cards_all ac

194: OPEN p_disputed_cursor FOR
195: SELECT transaction_date, merchant_name1, billed_amount, billed_currency_code
196: FROM
197: ap_credit_card_trxns cct,
198: ap_cards_all ac
199: WHERE
200: cct.card_program_id = p_cardProgramId
201: and cct.validate_code = 'Y'
202: and cct.payment_flag <> 'Y'

Line 970: AP_CARDS_all CARD ,

966: -- Determine if the user has Credit Card
967: SELECT 'Y'
968: INTO p_userHasCreditCard
969: FROM AP_CARD_PROGRAMS_all CP ,
970: AP_CARDS_all CARD ,
971: AP_LOOKUP_CODES ALC,
972: ( SELECT CARD_PROGRAM_ID,CARD_ID, PAYMENT_DUE_FROM_CODE
973: FROM AP_CREDIT_CARD_TRXNS_all
974: WHERE VALIDATE_CODE = 'Y'

Line 1880: ap_cards_all ac

1876: cct.transaction_amount,--Notification Esc
1877: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state) --Notification Esc
1878: from
1879: ap_credit_card_trxns cct,
1880: ap_cards_all ac
1881: where
1882: cct.card_program_id = p_cardProgramId
1883: and cct.validate_code = 'Y'
1884: and cct.payment_flag <> 'Y'

Line 1928: ap_cards_all ac,

1924: (
1925: SELECT DISTINCT cct.trx_id, cct.billed_amount amount
1926: FROM
1927: ap_credit_card_trxns_all cct,
1928: ap_cards_all ac,
1929: ap_expense_report_headers_all erh
1930: WHERE
1931: cct.card_program_id = p_cardProgramId
1932: and cct.validate_code = 'Y'

Line 1949: ap_cards_all ac

1945: UNION ALL
1946: SELECT DISTINCT cct.trx_id, cct.billed_amount amount
1947: FROM
1948: ap_credit_card_trxns_all cct,
1949: ap_cards_all ac
1950: WHERE
1951: cct.card_program_id = p_cardProgramId
1952: and cct.validate_code = 'Y'
1953: and cct.payment_flag <> 'Y'