APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 1196: ra_customer_trx_lines_all rl

1192: rl.customer_trx_line_id
1193: INTO x_out_rec.cm_trx_number,
1194: x_out_rec.cm_customer_trx_line_id
1195: FROM ra_customer_trx_all rx,
1196: ra_customer_trx_lines_all rl
1197: WHERE rx.customer_trx_id = x_cm_customer_trx_id
1198: AND rl.customer_trx_id = rx.customer_trx_id;
1199: END IF;
1200: x_out_rec.cm_customer_trx_id := x_cm_customer_trx_id;

Line 5551: l_deposit_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;

5547: invalid_value VARCHAR2(240);
5548: concat_err_msg VARCHAR2(2000);
5549: l_return_status VARCHAR2(1);
5550: l_cust_trx_name ra_cust_trx_types.NAME%TYPE;
5551: l_deposit_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
5552: l_emd_transactions_info pon_emd_trx_rec;
5553: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
5554: l_trx_number ra_customer_trx.trx_number%TYPE;
5555: l_memo_desc ar_memo_lines_all_tl.description%TYPE;

Line 5645: FROM ra_customer_trx_lines_all

5641:
5642: BEGIN
5643: SELECT customer_trx_line_id
5644: INTO l_deposit_trx_line_id
5645: FROM ra_customer_trx_lines_all
5646: WHERE customer_trx_id = p_in_rec.deposit_trx_id
5647: AND org_id = p_in_rec.org_id
5648: AND ROWNUM =1;
5649: EXCEPTION

Line 5871: FROM ra_customer_trx_all rc, ra_customer_trx_lines_all rcl

5867: SELECT rc.CUSTOMER_TRX_ID,
5868: rc.TRX_NUMBER
5869: INTO l_customer_trx_id,
5870: l_trx_number
5871: FROM ra_customer_trx_all rc, ra_customer_trx_lines_all rcl
5872: WHERE rc.CUSTOMER_TRX_ID = rcl.CUSTOMER_TRX_ID
5873: AND rcl.INTERFACE_LINE_CONTEXT = 'EMD TRANSACTIONS'
5874: AND rcl.INTERFACE_LINE_ATTRIBUTE7 = to_char(l_emd_transactions_info.emd_trx_group_id)
5875: AND rcl.INTERFACE_LINE_ATTRIBUTE8 = to_char(l_emd_transactions_info.emd_transaction_id)