APPS.JAI_JRG_OTH_TRIGGER_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 15: ln_org_unit_id JAI_CMN_INVENTORY_ORGS.org_unit_id%TYPE;

11: */
12: PROCEDURE BRI_T1 ( pr_old t_rec%type , pr_new in out t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
13: ln_balance number;
14: ln_balance_cnt number;
15: ln_org_unit_id JAI_CMN_INVENTORY_ORGS.org_unit_id%TYPE;
16: lv_register_type JAI_CMN_RG_OTH_BALANCES.register_type%TYPE;
17:
18: CURSOR cur_org_unit_id_pla IS
19: SELECT org_unit_id

Line 20: FROM JAI_CMN_INVENTORY_ORGS

16: lv_register_type JAI_CMN_RG_OTH_BALANCES.register_type%TYPE;
17:
18: CURSOR cur_org_unit_id_pla IS
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

Line 29: FROM JAI_CMN_INVENTORY_ORGS

25: AND pr_new.source_type = 2 );
26:
27: CURSOR cur_org_unit_id_rg23 IS
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