APPS.JAI_JRG_OTH_TRIGGER_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 32: FROM JAI_CMN_RG_23AC_II_TRXS

28: SELECT org_unit_id
29: FROM JAI_CMN_INVENTORY_ORGS
30: WHERE ( organization_id,location_id)
31: IN ( SELECT organization_id,location_id
32: FROM JAI_CMN_RG_23AC_II_TRXS
33: WHERE register_id = pr_new.source_register_id
34: AND pr_new.source_type = 1);
35:
36: CURSOR cur_balance

Line 47: FROM JAI_CMN_RG_23AC_II_TRXS

43: /*Bug 5141459 start*/
44: CURSOR cur_chk_consolidation( p_register_id NUMBER )
45: IS
46: SELECT 1
47: FROM JAI_CMN_RG_23AC_II_TRXS
48: WHERE register_id = p_register_id
49: AND transaction_source_num IS NULL
50: AND pr_new.source_type = 1
51: UNION