APPS.OKL_CREATE_ADJST_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 21: customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type

17: payment_schedule_id okl_txl_adjsts_lns_b.PSL_ID%type,
18: AMOUNT okl_txl_adjsts_lns_b.AMOUNT%type,
19: CODE_COMBINATION_ID okl_txl_adjsts_lns_b.CODE_COMBINATION_ID%type,
20: customer_trx_id ra_customer_trx_all.customer_trx_id%type,
21: customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
22: );
23: TYPE l_adj_lines_tbl_type IS TABLE OF l_adj_lines_rec_type INDEX BY BINARY_INTEGER;
24:
25: TYPE l_adj_hdr_rec_type IS RECORD

Line 83: ra_customer_trx_lines_all ln,

79: ,ln.customer_trx_id
80: ,ln.customer_trx_line_id
81: FROM okl_trx_ar_adjsts_v a,
82: okl_txl_adjsts_lns_v b,
83: ra_customer_trx_lines_all ln,
84: ar_payment_schedules_all ps,
85: okc_k_headers_b khr,
86: okc_k_lines_v kle,
87: okl_strm_type_v sty

Line 120: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;

116: ch NUMBER;
117: l_last_psl_id NUMBER;
118: l_last_trx_id NUMBER;
119: l_customer_trx_id ra_customer_trx_all.customer_trx_id%type;
120: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;
121:
122: BEGIN
123: IF(IS_DEBUG_PROCEDURE_ON) THEN
124: BEGIN

Line 355: from ra_customer_trx_lines_all ractrl,

351: /*SELECT DISTINCT(contract_number)
352: FROM okl_bpd_leasing_payment_trx_v
353: WHERE payment_schedule_id = cp_psl_id; */ -- Bug 6358836
354: select distinct ractrl.interface_line_attribute6
355: from ra_customer_trx_lines_all ractrl,
356: ar_payment_schedules_all aps
357: where aps.customer_trx_id = ractrl.customer_trx_id
358: and ractrl.line_type = 'LINE'
359: and aps.payment_schedule_id = cp_psl_id;

Line 374: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;

370:
371: l_adj_hdr_tbl l_adj_hdr_tbl_type;
372: l_adj_lines_tbl l_adj_lines_tbl_type;
373: l_customer_trx_id ra_customer_trx_all.customer_trx_id%type;
374: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;
375:
376: BEGIN
377: l_set_of_books_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID;
378: l_psl_id := p_psl_id;