APPS.AP_WEB_DB_CCARD_PKG dependencies on AP_CREDIT_CARD_TRXNS_ALL

Line 973: FROM AP_CREDIT_CARD_TRXNS_all

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'
975: AND PAYMENT_FLAG <> 'Y'
976: AND BILLED_AMOUNT IS NOT NULL
977: AND NVL ( CATEGORY , 'BUSINESS' ) <> 'DEACTIVATED' ) TRXN

Line 1263: UPDATE ap_credit_card_trxns_all

1259: p_invoice_id IN ccTrxn_companyPrepaidInvID
1260: ) RETURN BOOLEAN IS
1261: --------------------------------------------------------------------------------
1262: BEGIN
1263: UPDATE ap_credit_card_trxns_all
1264: SET company_prepaid_invoice_id = p_invoice_id
1265: WHERE trx_id = p_card_trxn_id;
1266:
1267: RETURN TRUE;

Line 1405: AP_CREDIT_CARD_TRXNS_ALL table.

1401: END isMultPayments;
1402: -------------------------------------------------------------------------------
1403: /*Written By :Amulya Mishra
1404: Purpose :Returns the UNIQUE PAYMENT_DUE_FROM_CODE from
1405: AP_CREDIT_CARD_TRXNS_ALL table.
1406: */
1407:
1408: FUNCTION getPaymentDueCodeFromTrxn(
1409: p_trxn_id IN ccTrxn_trxID)

Line 1927: ap_credit_card_trxns_all cct,

1923: FROM
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

Line 1948: ap_credit_card_trxns_all cct,

1944: and ac.employee_id = p_employeeId
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'