DBA Data[Home] [Help]

APPS.JAI_INV_MMT_TRIGGER_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 126: FROM JAI_CMN_INVENTORY_ORGS

122:
123: CURSOR range_division_cur (p_organization_id IN NUMBER, p_loc_id IN NUMBER)
124: IS
125: SELECT NVL (excise_duty_range, ' '), NVL (excise_duty_division, ' ')
126: FROM JAI_CMN_INVENTORY_ORGS
127: WHERE organization_id = p_organization_id AND location_id = p_loc_id;
128:
129: CURSOR srno_i_cur (
130: p_organization_id IN NUMBER,

Line 265: FROM JAI_CMN_INVENTORY_ORGS

261: /* -- cbabu 25/07/02 for Bug#2480524
262: CURSOR get_subinv_dtl_cur
263: IS
264: SELECT manufacturing, trading
265: FROM JAI_CMN_INVENTORY_ORGS
266: WHERE organization_id = pr_new.organization_id AND location_id = 0;
267: */
268: -- cbabu, to execute this trigger only for indian operating units
269: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%TYPE;