DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_POPU_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 4934: oe_transaction_types_tl ott

4930: SELECT
4931: ott.transaction_type_id
4932: FROM
4933: ra_customer_trx_all rct,
4934: oe_transaction_types_tl ott
4935: WHERE
4936: rct.customer_trx_id = pr_new.previous_customer_trx_id
4937: AND rct.interface_header_attribute2 = ott.name ;
4938:

Line 4950: ln_transaction_type_id OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID%TYPE;

4946: WHERE
4947: link_to_cust_trx_line_id = pr_new.customer_trx_line_id ;
4948:
4949:
4950: ln_transaction_type_id OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID%TYPE;
4951: ln_register_id JAI_OM_OE_BOND_REG_HDRS.REGISTER_ID%TYPE;
4952: lv_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
4953:
4954: CURSOR check_reference_existed