APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_CREDIT_CARD_TRXNS

Line 504: ap_credit_card_trxns cc,

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

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;