DBA Data[Home] [Help]

APPS.FV_RECEIVABLES_ACTIVITY_PKG dependencies on FV_INTERIM_CASH_RECEIPTS_ALL

Line 1166: FROM fv_interim_cash_receipts_all ficr,

1162: CURSOR CUR_1A_COL_ON_REC (p_receipt_number VARCHAR2 ,
1163: p_customer_trx_id NUMBER ,
1164: p_cash_receipt_id NUMBER )IS
1165: SELECT receipt_desc_type ,NVL(ficr.amount,0) amount
1166: FROM fv_interim_cash_receipts_all ficr,
1167: ar_cash_receipts_all acr,
1168: ar_cash_receipt_history_all acrh
1169: WHERE ficr.receipt_number = p_receipt_number
1170: AND ficr.customer_trx_id = p_customer_trx_id