DBA Data[Home] [Help]

APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_TXL_AR_INV_LNS_B

Line 951: CURSOR c_2level_cm(p_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE) IS

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
951: CURSOR c_2level_cm(p_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE) IS
952: SELECT 'X' FROM
953: OKL_TXL_AR_INV_LNS_B
954: WHERE ID = p_til_id
955: AND TIL_ID_REVERSES IS NULL;

Line 953: OKL_TXL_AR_INV_LNS_B

949:
950: -- Cursor to check if 2 level credit memo is on-account
951: CURSOR c_2level_cm(p_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE) IS
952: SELECT 'X' FROM
953: OKL_TXL_AR_INV_LNS_B
954: WHERE ID = p_til_id
955: AND TIL_ID_REVERSES IS NULL;
956:
957: l_on_acc_cm BOOLEAN;

Line 2888: FOR acc_no_dtls_rec IN acc_dstrs_csr(p_ie_tbl2(h).til_id, 'OKL_TXL_AR_INV_LNS_B')

2884: print_to_log('====>External Line Created.');
2885: END IF;
2886: */
2887: -- Create Accounting Distributions in the External Table
2888: FOR acc_no_dtls_rec IN acc_dstrs_csr(p_ie_tbl2(h).til_id, 'OKL_TXL_AR_INV_LNS_B')
2889: LOOP
2890: l_esd_cnt := l_esd_cnt + 1;
2891:
2892: esd_tbl(l_esd_cnt).xls_id := l_xls_id;