APPS.OKL_AM_BAL_WRITEOFF_PVT dependencies on OKL_BPD_TLD_AR_LINES_V

Line 763: FROM OKL_BPD_TLD_AR_LINES_V

759:
760: -- rmunjulu R12 Fixes - Billing fixes -- changes to this cursor as old bpd view does not work anymore
761: CURSOR k_balances_csr (p_khr_id IN NUMBER, p_trn_date DATE) IS
762: SELECT SUM(amount_due_remaining)
763: FROM OKL_BPD_TLD_AR_LINES_V
764: WHERE khr_id = p_khr_id
765: AND invoice_date <= sysdate;
766:
767: /* rmunjulu R12 Fixes - Billing fixes -- replaced with new cursor below

Line 815: FROM OKL_BPD_TLD_AR_LINES_V RACTRL,

811: APS.payment_schedule_id SCHEDULE_ID,
812: RACTRL.CUSTOMER_TRX_ID AR_INVOICE_NUMBER,
813: RACTRL.til_id_details TIL_ID,
814: RACTRL.TLD_ID TLD_ID
815: FROM OKL_BPD_TLD_AR_LINES_V RACTRL,
816: AR_PAYMENT_SCHEDULES_ALL APS
817: WHERE RACTRL.khr_id = p_khr_id
818: AND RACTRL.amount_due_remaining > 0
819: AND RACTRL.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID

Line 872: amount OKL_BPD_TLD_AR_LINES_V.AMOUNT%TYPE,

868: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
869:
870: TYPE ajlv_id_rec_type IS RECORD (
871: id NUMBER,
872: amount OKL_BPD_TLD_AR_LINES_V.AMOUNT%TYPE,
873: ar_invoice_number OKL_BPD_TLD_AR_LINES_V.CUSTOMER_TRX_ID%TYPE,
874: stream_meaning OKL_BPD_TLD_AR_LINES_V.STREAM_TYPE%TYPE);
875:
876: TYPE ajlv_id_tbl_type IS TABLE OF ajlv_id_rec_type INDEX BY BINARY_INTEGER;

Line 873: ar_invoice_number OKL_BPD_TLD_AR_LINES_V.CUSTOMER_TRX_ID%TYPE,

869:
870: TYPE ajlv_id_rec_type IS RECORD (
871: id NUMBER,
872: amount OKL_BPD_TLD_AR_LINES_V.AMOUNT%TYPE,
873: ar_invoice_number OKL_BPD_TLD_AR_LINES_V.CUSTOMER_TRX_ID%TYPE,
874: stream_meaning OKL_BPD_TLD_AR_LINES_V.STREAM_TYPE%TYPE);
875:
876: TYPE ajlv_id_tbl_type IS TABLE OF ajlv_id_rec_type INDEX BY BINARY_INTEGER;
877: ajlv_id_tbl ajlv_id_tbl_type;

Line 874: stream_meaning OKL_BPD_TLD_AR_LINES_V.STREAM_TYPE%TYPE);

870: TYPE ajlv_id_rec_type IS RECORD (
871: id NUMBER,
872: amount OKL_BPD_TLD_AR_LINES_V.AMOUNT%TYPE,
873: ar_invoice_number OKL_BPD_TLD_AR_LINES_V.CUSTOMER_TRX_ID%TYPE,
874: stream_meaning OKL_BPD_TLD_AR_LINES_V.STREAM_TYPE%TYPE);
875:
876: TYPE ajlv_id_tbl_type IS TABLE OF ajlv_id_rec_type INDEX BY BINARY_INTEGER;
877: ajlv_id_tbl ajlv_id_tbl_type;
878:

Line 1943: FROM OKL_BPD_TLD_AR_LINES_V RACTRL

1939: AND BPD.contract_id = CHR.id
1940: */
1941: -- rmunjulu R12 Fixes - Billing fixes -- changes to this select as old bpd view does not work anymore
1942: SELECT sum(RACTRL.amount_due_remaining)
1943: FROM OKL_BPD_TLD_AR_LINES_V RACTRL
1944: WHERE RACTRL.invoice_date <= sysdate
1945: AND RACTRL.khr_id = CHR.id
1946: );
1947: