APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_BPD_TLD_AR_LINES_V

Line 213: FROM okl_bpd_tld_ar_lines_v

209: -- CURSOR lsm_csr ( p_ref_sel_id NUMBER ) IS
210: CURSOR tld_csr ( p_ref_sel_id NUMBER ) IS
211: --end:| 14-Mar-2007 cklee Bug fixed for billing impact |
212: SELECT customer_trx_id
213: FROM okl_bpd_tld_ar_lines_v
214: WHERE sel_id = p_ref_sel_id AND
215: customer_trx_id IS NOT NULL;
216:
217: --start:| 14-Mar-2007 cklee Bug fixed for billing impact |

Line 219: l_recv_id okl_bpd_tld_ar_lines_v.customer_trx_id%TYPE;

215: customer_trx_id IS NOT NULL;
216:
217: --start:| 14-Mar-2007 cklee Bug fixed for billing impact |
218: -- l_recv_id okl_cnsld_ar_strms_b.receivables_invoice_id%TYPE;
219: l_recv_id okl_bpd_tld_ar_lines_v.customer_trx_id%TYPE;
220: --end:| 14-Mar-2007 cklee Bug fixed for billing impact |
221:
222: BEGIN
223:

Line 285: okl_bpd_tld_ar_lines_v TLD,

281: FROM
282: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
283: -- OKL_CNSLD_AR_STRMS_V LSM,
284: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
285: okl_bpd_tld_ar_lines_v TLD,
286: AR_PAYMENT_SCHEDULES_ALL PMTSCH,
287: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
288: WHERE
289: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK

Line 322: FROM okl_bpd_tld_ar_lines_v TLD,

318: SELECT PMTSCH.amount_due_original
319: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
320: -- FROM OKL_CNSLD_AR_STRMS_V LSM,
321: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
322: FROM okl_bpd_tld_ar_lines_v TLD,
323: AR_PAYMENT_SCHEDULES_ALL PMTSCH
324: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
325: -- WHERE LSM.ID = p_lsm_id AND
326: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK

Line 333: FROM okl_bpd_tld_ar_lines_v

329: PMTSCH.class = 'INV';
330: /*
331: CURSOR get_tld_id ( p_ref_sel_id NUMBER ) IS
332: SELECT TLD_ID
333: FROM okl_bpd_tld_ar_lines_v
334: WHERE sel_id = p_ref_sel_id;
335: */
336:
337: /*

Line 350: FROM okl_bpd_tld_ar_lines_v

346: -- CURSOR get_lsm_id ( p_ref_sel_id NUMBER ) IS
347: CURSOR get_tld_id ( p_ref_sel_id NUMBER ) IS
348: -- SELECT customer_trx_id
349: SELECT tld_id
350: FROM okl_bpd_tld_ar_lines_v
351: -- WHERE tld_id = p_ref_sel_id;
352: WHERE sel_id = p_ref_sel_id;
353: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
354:

Line 356: -- l_lsm_id okl_bpd_tld_ar_lines_v.customer_trx_id%TYPE;

352: WHERE sel_id = p_ref_sel_id;
353: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
354:
355: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
356: -- l_lsm_id okl_bpd_tld_ar_lines_v.customer_trx_id%TYPE;
357: l_tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;
358: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
359: l_total_rcpt_amt AR_RECEIVABLE_APPLICATIONS_ALL.amount_applied%TYPE;
360: l_total_bill_amt AR_PAYMENT_SCHEDULES_ALL.amount_due_original%TYPE;

Line 998: okl_bpd_tld_ar_lines_v TLD,

994: PMTSCH.amount_due_remaining,
995: TLD.TLD_ID TLD_ID,
996: TLD.LINE_amount AMOUNT
997: FROM
998: okl_bpd_tld_ar_lines_v TLD,
999: AR_PAYMENT_SCHEDULES_ALL PMTSCH,
1000: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP,
1001: ra_Customer_trx_Lines_All cUst_trx_Lines ,
1002: ar_Activity_Details arl

Line 1035: okl_bpd_tld_ar_lines_v TLD,

1031: PMTSCH.amount_due_remaining,
1032: TLD.TLD_ID TLD_ID,
1033: TLD.LINE_amount AMOUNT
1034: FROM
1035: okl_bpd_tld_ar_lines_v TLD,
1036: AR_PAYMENT_SCHEDULES_ALL PMTSCH,
1037: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
1038: WHERE
1039: TLD.TLD_ID = p_tld_id AND

Line 1074: FROM okl_bpd_tld_ar_lines_v TLD,

1070: TLD.amount_due_original amount_due_original,
1071: TLD.amount_due_remaining amount_due_remaining,
1072: TLD.TLD_ID TLD_ID,
1073: TLD.LINE_amount AMOUNT
1074: FROM okl_bpd_tld_ar_lines_v TLD,
1075: okl_receipt_applications_uv ARAPP,
1076: ar_distributions_all ad ,
1077: ra_customer_trx_lines_all ac
1078: WHERE TLD.TLD_ID = p_tld_id

Line 1122: FROM okl_bpd_tld_ar_lines_v TLD,

1118:
1119: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1120: CURSOR total_bill_amt_csr ( p_tld_id NUMBER ) IS
1121: SELECT PMTSCH.amount_due_original
1122: FROM okl_bpd_tld_ar_lines_v TLD,
1123: AR_PAYMENT_SCHEDULES_ALL PMTSCH
1124: WHERE TLD.TLD_ID = p_tld_id AND
1125: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1126: PMTSCH.customer_trx_id = TLD.customer_trx_id AND

Line 1293: FROM okl_bpd_tld_ar_lines_v

1289:
1290: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1291: CURSOR get_ref_tld_id ( p_ref_sel_id NUMBER ) IS
1292: SELECT tld_Id
1293: FROM okl_bpd_tld_ar_lines_v
1294: WHERE sel_id = p_ref_sel_id
1295: AND CUSTOMER_TRX_ID IS NOT NULL;
1296: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1297: