APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_TXD_AR_LN_DTLS_B

Line 944: CURSOR c_3level_cm(p_tld_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE) IS

940: WHERE INSTALLED_FLAG IN ('I', 'B');
941:
942: -- Start : Bug#5964007 : PRASJAIN
943: -- Cursor to check if 3 level credit memo is on-account
944: CURSOR c_3level_cm(p_tld_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE) IS
945: SELECT 'X' FROM
946: OKL_TXD_AR_LN_DTLS_B
947: WHERE ID = p_tld_id
948: AND TLD_ID_REVERSES IS NULL;

Line 946: OKL_TXD_AR_LN_DTLS_B

942: -- Start : Bug#5964007 : PRASJAIN
943: -- Cursor to check if 3 level credit memo is on-account
944: CURSOR c_3level_cm(p_tld_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE) IS
945: SELECT 'X' FROM
946: OKL_TXD_AR_LN_DTLS_B
947: WHERE ID = p_tld_id
948: AND TLD_ID_REVERSES IS NULL;
949:
950: -- Cursor to check if 2 level credit memo is on-account

Line 1812: FOR acc_dtls_rec IN acc_dstrs_csr(p_ie_tbl1(k).tld_id, 'OKL_TXD_AR_LN_DTLS_B')

1808: END IF;
1809: */
1810: -- Create External Distribution Lines from AR
1811: --print_to_log('TBL p_ie_tbl1(k).tld_id: ' || p_ie_tbl1(k).tld_id);
1812: FOR acc_dtls_rec IN acc_dstrs_csr(p_ie_tbl1(k).tld_id, 'OKL_TXD_AR_LN_DTLS_B')
1813: LOOP
1814: l_esd_cnt := l_esd_cnt + 1;
1815:
1816: esd_tbl(l_esd_cnt).xls_id := l_xls_id;

Line 3344: FROM okl_txd_ar_ln_dtls_b t3

3340: AND t2.tai_id = t1.id
3341: AND t4.id = t2.sty_id
3342: AND NOT EXISTS
3343: (SELECT *
3344: FROM okl_txd_ar_ln_dtls_b t3
3345: WHERE t3.til_id_details = t2.id)
3346: ORDER BY tai_id;
3347:
3348: -- Cursor picks lines with detail records