APPS.AR_BILLS_MAINTAIN_PUB dependencies on IBY_TRXN_EXTENSIONS_V

Line 200: l_instr_id iby_trxn_extensions_v.instr_assignment_id%type;

196: l_drawee_site_use_id ra_customer_trx.drawee_site_use_id%type;
197: l_org_id ra_customer_trx.org_id%type;
198: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%type;
199: l_created_from ra_customer_trx.created_from%type;
200: l_instr_id iby_trxn_extensions_v.instr_assignment_id%type;
201:
202:
203: BEGIN
204:

Line 274: iby_trxn_extensions_v iby

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
277: and brlines.customer_trx_id = p_customer_trx_id
278: and rownum = 1;