DBA Data[Home] [Help]

APPS.AR_BILLS_MAINTAIN_PUB dependencies on RA_CUSTOMER_TRX_LINES

Line 272: from ra_customer_Trx_lines brlines,

268:
269: Begin
270: Select instr_assignment_id
271: Into l_instr_id
272: from ra_customer_Trx_lines brlines,
273: ra_customer_trx ct,
274: iby_trxn_extensions_v iby
275: where ct.customer_trx_id = brlines.br_ref_customer_trx_id
276: and ct.payment_trxn_extension_id = iby.trxn_extension_id

Line 5040: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;

5036: l_trh_rec ar_transaction_history%ROWTYPE;
5037: l_ps_rec ar_payment_schedules%ROWTYPE;
5038: l_action_rec action_rec_type;
5039: l_status VARCHAR2(30);
5040: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
5041: l_msg_count NUMBER;
5042: l_msg_data VARCHAR2(2000);
5043: l_return_status VARCHAR2(1);
5044: