APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_CREDIT_CARD_TRXNS

Line 502: ap_credit_card_trxns cc,

498: l_emp_full_name,
499: p_ccard_amt,
500: p_total
501: FROM ap_expense_report_headers erh,
502: ap_credit_card_trxns cc,
503: /* hr_employees emp Bug 3006221 */
504: per_people_f emp,
505: ap_cards aca,
506: iby_creditcard icc

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;