DBA Data[Home] [Help]

APPS.JAI_JRG_OTH_TRIGGER_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 23: FROM JAI_CMN_RG_PLA_TRXS

19: SELECT org_unit_id
20: FROM JAI_CMN_INVENTORY_ORGS
21: WHERE (organization_id,location_id)
22: IN ( SELECT organization_id,location_id
23: FROM JAI_CMN_RG_PLA_TRXS
24: WHERE register_id = pr_new.source_register_id
25: AND pr_new.source_type = 2 );
26:
27: CURSOR cur_org_unit_id_rg23 IS

Line 53: FROM JAI_CMN_RG_PLA_TRXS

49: AND transaction_source_num IS NULL
50: AND pr_new.source_type = 1
51: UNION
52: SELECT 1
53: FROM JAI_CMN_RG_PLA_TRXS
54: WHERE register_id = p_register_id
55: AND ( transaction_source_num IS NULL OR tr6_source='CONSOLIDATION' or tr6_source='MANUAL') /*ADDED or tr6_source='MANUAL' for bug #5894216*/
56: AND pr_new.source_type = 2;
57: