DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_BPD_TLD_AR_LINES_V

Line 6626: okl_bpd_tld_ar_lines_v LSM,

6622: /*
6623: 16-Aug-2007, ankushar Bug# 5499193
6624: start changes, modified the cursor to replace reference to okl_cnsld_ar_strms_b
6625: */
6626: okl_bpd_tld_ar_lines_v LSM,
6627: -- OKC_K_HEADERS_B CHR, commenting unused table, ankushar Bug# 5499193
6628: /* 16-Aug-2007 ankushar end changes */
6629: OKC_K_LINES_B CLE,
6630: OKC_LINE_STYLES_B LSE

Line 6686: okl_bpd_tld_ar_lines_v LSM,

6682: /*
6683: 16-Aug-2007, ankushar Bug# 5499193
6684: start changes, modified the cursor to replace reference to okl_cnsld_ar_strms_b
6685: */
6686: okl_bpd_tld_ar_lines_v LSM,
6687: -- OKC_K_HEADERS_B CHR, commenting unused table, ankushar Bug# 5499193
6688: /* 16-Aug-2007 ankushar end changes */
6689: OKC_K_LINES_B CLE,
6690: OKC_LINE_STYLES_B LSE

Line 8975: FROM okl_bpd_tld_ar_lines_v ocas

8971:
8972: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
8973: p_grace_days IN NUMBER) IS
8974: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
8975: FROM okl_bpd_tld_ar_lines_v ocas
8976: ,ar_payment_schedules aps
8977: , okl_strm_type_v sm
8978: WHERE ocas.khr_id = p_contract_id
8979: AND ocas.customer_trx_id = aps.customer_trx_id