APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_CREDIT_CARD_TRXNS_ALL

Line 1432: AP_CREDIT_CARD_TRXNS_ALL table based upon

1428: -------------------------------------------------------------------
1429:
1430: /*Written By :Amulya Mishra
1431: Purpose :Returns the PAYMENT_DUE_FROM_CODE from
1432: AP_CREDIT_CARD_TRXNS_ALL table based upon
1433: report_header_id.
1434: */
1435: FUNCTION getPaymentDueFromReport(
1436: p_report_header_id IN expHdr_headerID,

Line 1448: FROM ap_credit_card_trxns_all trx

1444: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_CCARD_PKG', 'start getPaymentDueFromReport');
1445:
1446: SELECT payment_due_from_code
1447: INTO p_paymentDueFromCode
1448: FROM ap_credit_card_trxns_all trx
1449: WHERE trx.report_header_id = p_report_header_id
1450: AND rownum = 1; --Data Corruption might give two Distinct Pay Methods.
1451:
1452: return TRUE;