APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKL_TRX_CSH_RCPT_ALL_B

Line 1642: FROM okl_trx_csh_rcpt_all_b a, okl_txl_rcpt_apps_b b,

1638:
1639: --gkhuntet - FP Bug 5516814..start
1640: CURSOR c_get_adv_rcpt_for_cont(cp_cont_number IN VARCHAR2) IS
1641: SELECT DISTINCT c.contract_number
1642: FROM okl_trx_csh_rcpt_all_b a, okl_txl_rcpt_apps_b b,
1643: okc_k_headers_b c
1644: WHERE a.FULLY_APPLIED_FLAG = 'N'
1645: AND a.receipt_type = 'ADV'
1646: AND a.id = b.rct_id_details