APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_CREDIT_CARD_TRXNS_ALL

Line 1446: AP_CREDIT_CARD_TRXNS_ALL table based upon

1442: -------------------------------------------------------------------
1443:
1444: /*Written By :Amulya Mishra
1445: Purpose :Returns the PAYMENT_DUE_FROM_CODE from
1446: AP_CREDIT_CARD_TRXNS_ALL table based upon
1447: report_header_id.
1448: */
1449: FUNCTION getPaymentDueFromReport(
1450: p_report_header_id IN expHdr_headerID,

Line 1462: FROM ap_credit_card_trxns_all trx

1458: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_CCARD_PKG', 'start getPaymentDueFromReport');
1459:
1460: SELECT payment_due_from_code
1461: INTO p_paymentDueFromCode
1462: FROM ap_credit_card_trxns_all trx
1463: WHERE trx.report_header_id = p_report_header_id
1464: AND rownum = 1; --Data Corruption might give two Distinct Pay Methods.
1465:
1466: return TRUE;