APPS.BOM_DELETE_ENTITY dependencies on MTL_PARAMETERS

Line 125: FROM MTL_PARAMETERS MP

121: org_list in out nocopy /* file.sql.39 change */ inv_orghierarchy_pvt.orgid_tbl_type)
122: IS
123: CURSOR orgs is
124: SELECT MP.organization_id
125: FROM MTL_PARAMETERS MP
126: WHERE MP.master_organization_id = (select m.master_organization_id
127: from mtl_parameters m
128: where m.organization_id = current_org_id)
129: and

Line 127: from mtl_parameters m

123: CURSOR orgs is
124: SELECT MP.organization_id
125: FROM MTL_PARAMETERS MP
126: WHERE MP.master_organization_id = (select m.master_organization_id
127: from mtl_parameters m
128: where m.organization_id = current_org_id)
129: and
130: exists ( select 'x'
131: from org_access_view

Line 137: l_org_id mtl_parameters.organization_id%type;

133: to_number(FND_PROFILE.value('RESP_ID')) and
134: resp_application_id =
135: to_number(FND_PROFILE.value('RESP_APPL_ID'))
136: );
137: l_org_id mtl_parameters.organization_id%type;
138: l_index NUMBER := 0;
139: BEGIN
140: l_index := nvl(org_list.LAST,0);
141: If (org_type = 1) then