DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_CASH_APP_PVT dependencies on OKL_RECEIPT_DETAILS_UV

Line 557: FROM okl_receipt_Details_uv

553:
554: -- verify on account receipt amount
555: CURSOR c_ver_on_acct_amt(cp_csh_rcpt_id IN NUMBER) IS
556: SELECT (unapplied_amount + onaccount_amount) amount_available
557: FROM okl_receipt_Details_uv
558: WHERE cash_Receipt_id = cp_csh_rcpt_id;
559:
560: -------------------------------------------------------------------------------
561:

Line 2023: FROM okl_receipt_Details_uv

2019:
2020: -- verify on account receipt amount
2021: CURSOR c_ver_on_acct_amt(cp_csh_rcpt_id IN NUMBER) IS
2022: SELECT (unapplied_amount + onaccount_amount) amount_available
2023: FROM okl_receipt_Details_uv
2024: WHERE cash_receipt_id = cp_csh_rcpt_id;
2025:
2026: -------------------------------------------------------------------------------
2027:

Line 2805: FROM okl_receipt_Details_uv

2801:
2802: -- verify on account receipt amount
2803: CURSOR c_ver_on_acct_amt(cp_csh_rcpt_id IN NUMBER) IS
2804: SELECT (unapplied_amount + onaccount_amount) amount_available
2805: FROM okl_receipt_Details_uv
2806: WHERE cash_receipt_id = cp_csh_rcpt_id;
2807:
2808:
2809: -------------------------------------------------------------------------------

Line 3389: FROM okl_receipt_Details_uv

3385:
3386: -- verify on account receipt amount
3387: CURSOR c_ver_on_acct_amt(cp_csh_rcpt_id IN NUMBER) IS
3388: SELECT onaccount_amount amount_available
3389: FROM okl_receipt_Details_uv
3390: WHERE cash_receipt_id = cp_csh_rcpt_id;
3391:
3392: -------------------------------------------------------------------------------
3393: