APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKL_TXL_RCPT_APPS_B

Line 1850: FROM okl_trx_csh_rcpt_all_b a, okl_txl_rcpt_apps_b b,

1846:
1847: --gkhuntet - FP Bug 5516814..start
1848: CURSOR c_get_adv_rcpt_for_cont(cp_cont_number IN VARCHAR2) IS
1849: SELECT DISTINCT c.contract_number
1850: FROM okl_trx_csh_rcpt_all_b a, okl_txl_rcpt_apps_b b,
1851: okc_k_headers_b c
1852: WHERE a.FULLY_APPLIED_FLAG = 'N'
1853: AND a.receipt_type = 'ADV'
1854: AND a.id = b.rct_id_details