APPS.OKL_BTCH_CASH_APPLIC dependencies on OKL_TRX_CSH_RECEIPT_V

Line 66: okl_trx_csh_receipt_v b

62: a.irm_id,
63: 'x',
64: trx_status_code
65: FROM okl_trx_csh_batch_v a,
66: okl_trx_csh_receipt_v b
67: WHERE a.id = cp_btc_id
68: AND a.id = b.btc_id
69: AND rownum = 1;
70:

Line 74: FROM okl_trx_csh_receipt_v a

70:
71: -- check for unique check number
72: CURSOR c_unique_check(cp_check_number IN VARCHAR2, cp_amount IN NUMBER, cp_customer_id IN NUMBER, cp_receipt_date IN DATE) IS
73: SELECT check_number
74: FROM okl_trx_csh_receipt_v a
75: WHERE a.check_number = cp_check_number
76: AND a.amount = cp_amount
77: AND a.ile_id = cp_customer_id
78: AND a.date_effective = trunc(cp_receipt_date);

Line 321: okl_trx_csh_receipt_v b

317: CURSOR c_get_btc_dtls(cp_btc_id IN VARCHAR2) IS
318: SELECT date_gl_requested,
319: a.irm_id
320: FROM okl_trx_csh_batch_v a,
321: okl_trx_csh_receipt_v b
322: WHERE a.id = cp_btc_id
323: AND a.id = b.btc_id
324: AND rownum = 1;
325: --cursor to get receipt application id

Line 546: okl_trx_csh_receipt_v b

542: CURSOR c_get_btc_dtls(cp_btc_id IN VARCHAR2) IS
543: SELECT date_gl_requested,
544: a.irm_id
545: FROM okl_trx_csh_batch_v a,
546: okl_trx_csh_receipt_v b
547: WHERE a.id = cp_btc_id
548: AND a.id = b.btc_id
549: AND rownum = 1;
550: BEGIN

Line 997: okl_trx_csh_receipt_v b

993: -- get new batch details
994: CURSOR c_get_btc_dtls(cp_btc_id IN VARCHAR2) IS
995: SELECT 'x'
996: FROM okl_trx_csh_batch_v a,
997: okl_trx_csh_receipt_v b
998: WHERE a.id = cp_btc_id
999: AND a.id = b.btc_id
1000: AND rownum = 1;
1001:

Line 1007: FROM okl_trx_csh_receipt_v a

1003:
1004: -- check for unique check number
1005: CURSOR c_unique_check(cp_check_number IN VARCHAR2, cp_amount IN NUMBER, cp_customer_id IN NUMBER, cp_receipt_date IN DATE) IS
1006: SELECT check_number
1007: FROM okl_trx_csh_receipt_v a
1008: WHERE a.check_number = cp_check_number
1009: AND a.amount = cp_amount
1010: AND a.ile_id = cp_customer_id
1011: AND a.date_effective = trunc(cp_receipt_date);