DBA Data[Home] [Help]

APPS.OKL_PAY_CURE_REFUNDS_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 1783: okl_txd_ar_ln_dtls_b txd,

1779: tai.amount amount,
1780: tai.currency_code currency_code
1781: from okl_trx_ar_invoices_b tai,
1782: okl_txl_ar_inv_lns_b til,
1783: okl_txd_ar_ln_dtls_b txd,
1784: okl_cure_refunds crf
1785: where crf.cure_refund_header_id = p_refund_header_id
1786: and tai.id = crf.tai_id
1787: and tai.id = til.tai_id

Line 1945: l_dist_info_tbl(1).source_table := 'OKL_TXD_AR_LN_DTLS_B';

1941:
1942: l_dist_info_tbl(1).source_id := j.txd_id;
1943: --start: cklee 06/28/07
1944: -- l_dist_info_tbl(1).source_table := 'OKL_TXL_AR_INV_LNS_B';
1945: l_dist_info_tbl(1).source_table := 'OKL_TXD_AR_LN_DTLS_B';
1946: --end: cklee 06/28/07
1947: l_dist_info_tbl(1).accounting_date := j.date_invoiced;
1948: l_dist_info_tbl(1).gl_reversal_flag :='N';
1949: l_dist_info_tbl(1).post_to_gl :='N';

Line 3122: -- OKL_TXD_AR_LN_DTLS_B

3118: -- Start of comments
3119: --
3120: -- Procedure Name : additional_tld_attr
3121: -- Description : Internal procedure to add additional columns for
3122: -- OKL_TXD_AR_LN_DTLS_B
3123: -- Business Rules :
3124: -- Parameters :
3125: --
3126: -- Version : 1.0

Line 3175: l_rounded_amount OKL_TXD_AR_LN_DTLS_B.amount%TYPE;

3171:
3172: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
3173: l_precision fnd_currencies.PRECISION %TYPE;
3174:
3175: l_rounded_amount OKL_TXD_AR_LN_DTLS_B.amount%TYPE;
3176:
3177: -- to get inventory_org_id bug 4890024 begin
3178: CURSOR inv_org_id_csr(p_contract_id NUMBER) IS
3179: SELECT NVL(inv_organization_id, -99)