APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 4677: oe_transaction_types_tl ott

4673: SELECT
4674: ott.transaction_type_id
4675: FROM
4676: ra_customer_trx_all rct,
4677: oe_transaction_types_tl ott
4678: WHERE
4679: rct.customer_trx_id = nvl(pr_new.previous_customer_trx_id ,pr_new.customer_trx_id) --added nvl for bug#10156485
4680: /* bug 4926865. Added by Lakshmi Gopalsami
4681: Removed the upper as the data getting inserted into

Line 4683: oe_transaction_types_tl

4679: rct.customer_trx_id = nvl(pr_new.previous_customer_trx_id ,pr_new.customer_trx_id) --added nvl for bug#10156485
4680: /* bug 4926865. Added by Lakshmi Gopalsami
4681: Removed the upper as the data getting inserted into
4682: interface_header_attribute2 will be same as name in
4683: oe_transaction_types_tl
4684: */
4685: AND rct.interface_header_attribute2 = ott.name ;
4686:
4687: /*added by csahoo for bug#6407648, start*/

Line 4698: ln_transaction_type_id OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID%TYPE;

4694: WHERE
4695: link_to_cust_trx_line_id = pr_new.customer_trx_line_id ;
4696: /*added by csahoo for bug#6407648, end*/
4697:
4698: ln_transaction_type_id OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID%TYPE;
4699: ln_register_id JAI_OM_OE_BOND_REG_HDRS.REGISTER_ID%TYPE;
4700: lv_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
4701: /*
4702: || End of bug4567935 (115 bug4404898)