APPS.JAI_GENERAL_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 308: FROM JAI_CMN_INVENTORY_ORGS

304: FUNCTION get_orgn_master_flag(p_organization_id IN NUMBER, p_location_id IN NUMBER) RETURN VARCHAR2 IS
305:
306: CURSOR c_master_flag IS
307: SELECT master_org_flag
308: FROM JAI_CMN_INVENTORY_ORGS
309: WHERE organization_id = p_organization_id
310: AND location_id = p_location_id;
311:
312: lv_master_flag JAI_CMN_INVENTORY_ORGS.master_org_flag%TYPE;

Line 312: lv_master_flag JAI_CMN_INVENTORY_ORGS.master_org_flag%TYPE;

308: FROM JAI_CMN_INVENTORY_ORGS
309: WHERE organization_id = p_organization_id
310: AND location_id = p_location_id;
311:
312: lv_master_flag JAI_CMN_INVENTORY_ORGS.master_org_flag%TYPE;
313: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.get_orgn_master_flag';
314: BEGIN
315: OPEN c_master_flag;
316: FETCH c_master_flag INTO lv_master_flag;