APPS.OKL_BPD_ADVANCED_CASH_APP_PVT dependencies on OKL_RCPT_CUST_CONT_BALANCES_UV

Line 574: FROM okl_rcpt_cust_cont_balances_uv lpt

570: ,lpt.ar_invoice_number
571: ,lpt.trx_date
572: ,lpt.customer_acct_id
573: ,lpt.khr_id
574: FROM okl_rcpt_cust_cont_balances_uv lpt
575: WHERE lpt.contract_number = cp_contract_num
576: AND lpt.customer_account_number = NVL (cp_customer_num, lpt.customer_account_number)
577: AND lpt.status = 'OP'
578: AND lpt.amount_due_remaining > 0

Line 1032: FROM okl_rcpt_cust_cont_balances_uv lpt

1028: ,lpt.AR_INVOICE_NUMBER
1029: ,lpt.trx_date
1030: ,lpt.ar_invoice_id
1031: ,lpt.invoice_line_id
1032: FROM okl_rcpt_cust_cont_balances_uv lpt
1033: WHERE lpt.contract_number = cp_contract_num
1034: AND lpt.customer_account_number = NVL (cp_customer_num, lpt.customer_account_number)
1035: AND lpt.status = 'OP'
1036: AND lpt.amount_due_remaining > 0

Line 1369: FROM okl_rcpt_cust_cont_balances_uv lpt

1365: ,lpt.ar_invoice_number
1366: ,lpt.trx_date
1367: ,lpt.ar_invoice_id
1368: ,lpt.invoice_line_id
1369: FROM okl_rcpt_cust_cont_balances_uv lpt
1370: WHERE lpt.contract_number = cp_contract_num
1371: AND lpt.customer_account_number = NVL (cp_customer_num, lpt.customer_account_number)
1372: AND lpt.sty_id = NVL (cp_stream_type_id, lpt.sty_id)
1373: AND lpt.status = 'OP'

Line 1917: FROM okl_rcpt_cust_cont_balances_uv lpt

1913: lpt.khr_id,
1914: lpt.start_date,
1915: lpt.currency_code,
1916: lpt.customer_account_number
1917: FROM okl_rcpt_cust_cont_balances_uv lpt
1918: WHERE lpt.customer_account_number = nvl(cp_customer_num,lpt.customer_account_number)
1919: AND lpt.contract_number = NVL(cp_contract_num,lpt.contract_number)
1920: AND lpt.status = 'OP'
1921: AND lpt.amount_due_remaining > 0

Line 2043: FROM okl_rcpt_cust_cont_balances_uv lpt

2039: ,lpt.customer_acct_id
2040: ,lpt.khr_id
2041: ,lpt.ar_invoice_id
2042: ,lpt.invoice_line_id
2043: FROM okl_rcpt_cust_cont_balances_uv lpt
2044: WHERE lpt.contract_number = cp_contract_num
2045: AND lpt.customer_account_number = NVL (cp_customer_num, lpt.customer_account_number)
2046: AND lpt.sty_id = NVL (cp_stream_type_id, lpt.sty_id)
2047: AND lpt.status = 'OP'

Line 2839: FROM okl_rcpt_cust_cont_balances_uv lpt

2835: cp_receipt_currency IN VARCHAR2) IS
2836: SELECT DISTINCT(lpt.contract_number),
2837: lpt.khr_id,
2838: lpt.start_date
2839: FROM okl_rcpt_cust_cont_balances_uv lpt
2840: WHERE lpt.customer_account_number = cp_customer_num
2841: AND lpt.status = 'OP'
2842: AND lpt.amount_due_remaining > 0
2843: AND lpt.currency_code = NVL (cp_receipt_currency,lpt.currency_code)

Line 2856: FROM okl_rcpt_cust_cont_balances_uv lpt

2852: -- Changed CURSOR c_open_invs SQL definition
2853: -- get contract total
2854: CURSOR c_open_invs ( cp_contract_num IN VARCHAR2) IS
2855: SELECT lpt.customer_account_number
2856: FROM okl_rcpt_cust_cont_balances_uv lpt
2857: WHERE lpt.contract_number = cp_contract_num
2858: AND lpt.status = 'OP'
2859: AND lpt.amount_due_remaining > 0
2860: AND rownum < 2;