APPS.JAI_GENERAL_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 287: FROM JAI_CMN_INVENTORY_ORGS

283: FUNCTION get_orgn_master_flag(p_organization_id IN NUMBER, p_location_id IN NUMBER) RETURN VARCHAR2 IS
284:
285: CURSOR c_master_flag IS
286: SELECT master_org_flag
287: FROM JAI_CMN_INVENTORY_ORGS
288: WHERE organization_id = p_organization_id
289: AND location_id = p_location_id;
290:
291: lv_master_flag JAI_CMN_INVENTORY_ORGS.master_org_flag%TYPE;

Line 291: lv_master_flag JAI_CMN_INVENTORY_ORGS.master_org_flag%TYPE;

287: FROM JAI_CMN_INVENTORY_ORGS
288: WHERE organization_id = p_organization_id
289: AND location_id = p_location_id;
290:
291: lv_master_flag JAI_CMN_INVENTORY_ORGS.master_org_flag%TYPE;
292: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.get_orgn_master_flag';
293: BEGIN
294: OPEN c_master_flag;
295: FETCH c_master_flag INTO lv_master_flag;